| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula based on 2 pre-conditions
Thank you very much Bernard, I appreciate the quick reply!
"PSmith" wrote: Can anyone tell me what is wrong with the following formula? I only want the division part of the formula to be executed if the previous two conditions are both satisfied, if either one isn't satisfied, then I'd like it to return the "--" value but I can't seem to get the parentheses right. Many thanks. =IF(D57<"NA"& IF(D220,D22/D57,"--")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on 2 conditions | Excel Discussion (Misc queries) | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Formula based on conditions | Excel Worksheet Functions | |||
| Formula to Extract value on 3 column based on two conditions | Excel Discussion (Misc queries) | |||
| Use different formula to calculation based on conditions | Excel Discussion (Misc queries) | |||
Hybrid Mode
