formula inside a formula

[aiqtadar]

i'm trying to make a question in an excel quiz so that it calculates
the answer within a formula

here is an example

http://i86.photobucket.com/albums/k96/georgeforemans/img.jpg

where the ****'s are, i want it to calculate 30-B13 (the destination
cell) inside the same formula, as the value_if_false.

how would i go about doing this?

 

[JE McGimpsey]

One way:

....,"You need to do " & 30 - B13)

 

[aiqtadar]

how would i enter that exactly, into the cell?

One way:

....,"You need to do " & 30 - B13)

 

[aiqtadar]

never mind, that really helped.

by the way, after the b13, how do i make it so that it says "minutes
more exersize per day" in that formula.

many thanks...

how would i enter that exactly, into the cell?

 

[Fred Smith]

The same way you put "you need to do" before the result. Why would it be any
different? Try:

.... "You need to do " & 30 - b13 & "minutes more exercise per day")

--
Regards,
Fred

never mind, that really helped.

by the way, after the b13, how do i make it so that it says "minutes
more exersize per day" in that formula.

many thanks...