Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I set up equations that if the answer is false that it sk.
I am setting up a spreadsheet to compute different answers depending on the
value. I did set up the equation with the IF option but I need more than one IF option in the equation. Is it possible to setup the equation that if the IF is not true it skips to another cell with another equation? |
#2
|
|||
|
|||
Hi
you can have more than one IF in a cell (and no, a formula can't move you to another cell). To put more than one IF in a cell use the following structure =IF(test,IF(test,true,false),IF(test,true,false)) here another IF is embedded in both the true and false parts of the original IF - you can embed up to7 IFs in each part. if you have trouble constructing the IF post back with the criteria and cell references. Cheers JulieD "Mcarlson" wrote in message ... I am setting up a spreadsheet to compute different answers depending on the value. I did set up the equation with the IF option but I need more than one IF option in the equation. Is it possible to setup the equation that if the IF is not true it skips to another cell with another equation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with array equations | Excel Discussion (Misc queries) | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |