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

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

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

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

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

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
---

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