Equation in text string?

H

hoising8

Is it possible to have an equation within a text string. For example, could
I have a text string that says, "The average number of hours worked this week
was __". And have the blank be an average of cells I assign it?
 
B

Biff

Hi!

Try this:

="The average number of hours worked this week was
"&AVERAGE(range_to_average)

Biff
 
T

Tom Ogilvy

="The average number of hours worked this week was " &
TEXT(AVERAGE(A1:A7),"hh")
 
F

FSt1

hi,
yes you can. depending. you didn't say where the text string would be....so
i'm guessing and assuming your average of cell is in A1 and that we are going
to shorten the text.
on the sheet in cell iv2.... ="the average is " & A1

In a message box....
Sub test1()
msgbox("the average is " & A1)
end sub

regards
hope this helps
FSt1
 
Top