| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula inside a formula
Try this:
=IF(B13=30,"Keep it up","You need to do "&(30-B13)) Hope this helps. Pete On Jan 24, 12:38 pm, " 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| formula inside a formula | Excel Discussion (Misc queries) | |||
| Is it possible? | Excel Worksheet Functions | |||
| How can I place a formula inside another formula? | Excel Worksheet Functions | |||
| Using a value from a cell inside a formula! | Excel Discussion (Misc queries) | |||
Linear Mode
