| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
nesting for 2 dependents, and 4 formula options
I want to choose one of four formulas to use, conditional on the contents of
two cells i.e. If a1="male" and a230, (0.048*a3)+3.653, if a1="male' and a260, (0.049*a3)+2.459, if for two more formulas I was trying to do a combined =IF(AND, but this doesn't seem to be nestable.... Any help appreciated.... TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nesting if formula | Excel Discussion (Misc queries) | |||
| Nesting of more than 7 in an IF formula | Excel Worksheet Functions | |||
| CORREL formula work on multiple dependents | Excel Worksheet Functions | |||
| Can you help nesting a formula? | Excel Worksheet Functions | |||
| NESTING FORMULA | Excel Worksheet Functions | |||
Threaded Mode
