formula inside a formula
 

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/k9...remans/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?

formula inside a formula
 

One way:

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




In article .com,
" wrote:

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/k9...remans/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?

formula inside a formula
 

how would i enter that exactly, into the cell?

On Jan 24, 12:44 pm, JE McGimpsey wrote:
One way:

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

In article .com,



" wrote:
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/k9...remans/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?- Hide quoted text -- Show quoted text -

formula inside a formula
 

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...

On Jan 24, 12:54 pm, "
wrote:
how would i enter that exactly, into the cell?

On Jan 24, 12:44 pm, JE McGimpsey wrote:



One way:

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

In article .com,

" wrote:
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/k9...remans/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?- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

formula inside a formula
 

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


wrote in message
ups.com...
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...

On Jan 24, 12:54 pm, "
wrote:
how would i enter that exactly, into the cell?

On Jan 24, 12:44 pm, JE McGimpsey wrote:



One way:

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

In article .com,

" wrote:
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/k9...remans/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?- Hide quoted text -- Show quoted text --
Hide quoted text -- Show quoted text -

formula inside a formula
 

like this:
...., "You need to do " & 30 - B13 & " minutes more exercise per day.")

the ampersand (&) says to concatenate values together into one long string
of text.

" wrote:

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...

On Jan 24, 12:54 pm, "
wrote:
how would i enter that exactly, into the cell?

On Jan 24, 12:44 pm, JE McGimpsey wrote:



One way:

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

In article .com,

" wrote:
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/k9...remans/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?- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -