Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
I have the following if statement.
The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
Your first 2 IF statements, D10<K10 and D10=K10, well D10 will always meet
one of those 2 criteria, so will never worry about D10=0. You need to evaluate that first: =IF(D10=0,0,IF(D10<K10,L10,F10)) Hope this helps. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "ACarella" wrote: I have the following if statement. The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
Maybe
=IF(D10="","",IF(D10<L10,L10,IF(D10=K10,F10))) or =IF(D10="",0,IF(D10<L10,L10,IF(D10=K10,F10))) Miek "ACarella" wrote: I have the following if statement. The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
The first 2 IFs cover ALL possible situations. The 3rd IF is never going
to be used. ACarella wrote: I have the following if statement. The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
Or you could even do this:
=(D10=0)*((D10=0)*K10+(D10<0)*L10) -- ** John C ** "John C" wrote: Your first 2 IF statements, D10<K10 and D10=K10, well D10 will always meet one of those 2 criteria, so will never worry about D10=0. You need to evaluate that first: =IF(D10=0,0,IF(D10<K10,L10,F10)) Hope this helps. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "ACarella" wrote: I have the following if statement. The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
If cell B10 is blank, then return the value in D10
It should actually look like this: =IF(B10="",D10) As for your main: =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) Try this revision/re-sequenced: =IF(D10="",0,IF(D10<K10,L10,F10)) which checks for D10 being blank/containing formula blanks ahead of its subsequent comparison with values in other cell -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested if
Sorry it took me so long.
That did it Jon C. Thank you very much. Arlene "John C" wrote: Your first 2 IF statements, D10<K10 and D10=K10, well D10 will always meet one of those 2 criteria, so will never worry about D10=0. You need to evaluate that first: =IF(D10=0,0,IF(D10<K10,L10,F10)) Hope this helps. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "ACarella" wrote: I have the following if statement. The third IF statement is not working. Please help. Thank you. Arlene =IF(D10<K10,L10,IF(D10=K10,F10,IF(D10=0,0.00))) the 3rd IF statement can also be interpreted as IF(B10=' ',D10))) If cell B10 is blank, then return the value in D10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF with nested AND | Excel Discussion (Misc queries) | |||
nested ifs not enough | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If / And / Or ? | Excel Discussion (Misc queries) | |||
Nested IF | Excel Discussion (Misc queries) |