| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula based on 2 pre-conditions
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,"--")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formula based on 2 pre-conditions
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,"--")) In the help file, search for "Logical Functions" and then select "AND worksheet function". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formula based on 2 pre-conditions
=IF(AND(D57<"NA", D220),D22/D57,"--")
but if you have #N/A in D57 from a formula then =IF(AND(NOT(ISNA(D57), D220),D22/D57,"--") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "PSmith" wrote in message ... 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,"--")) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formula based on 2 pre-conditions
Hi P. Smith
Try it this way =IF(AND(D57<"NA",D220),D22/D57,"--") HTH John "PSmith" wrote in message ... 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,"--")) |
|
#5
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
