IF Statement - Nested - Error saying Missing Parentheses

[zaimink]

Hi Team

I am trying to set up a waiting list calculation for my client and am using a nested IF AND statement for the first time.

I get the error that I am missing parentheses but I don't know where??

=if(and(d4="", b4<>"",$b$1-b4,0),IF(and(d4<>"",b4<>"",d4-b4,)

** if d4 is empty and b4 is not empty - use b1-b4 as the formula
** if d4 is not empty and b4 is not empty - use d4-b4 as the formula

I even added an extra parentheses at the end and then it tells me it is not sure whether I want to enter a formula or text and tells me to click Help.

I'm not sure now what is wrong with the formula....can anyone assist?

[gak67]

=if(and(d4="", b4<>""),$b$1-b4,IF(and(d4<>"",b4<>""),d4-b4,0))

[shirleyxls]

Try this:

=IF(AND(D4="",B4<>""),$B$1-B4,IF(AND(D4<>"",B4<>""),D4-B4,0))

[gak67]

Just realised there is a simpler way to do this:
=IF(B4="",0,IF(D4="",$B$1-B4,D4-B4))
or
=IF(B4="",0,IF(D4="",$B$1,D4)-B4)

[vlady]

how about if
B4 is empty
D4 is not empty

[gak67]

how about if
B4 is empty
D4 is not empty

Because zaiminc had the ,0 in their first IF statement I assumed that if B4 is empty the result will be 0, regardless of what is in D4. If this is wrong and they can explain their logic further I will amend the formula.

[vlady]

oopps sorry..
question was for the OP for further clarifications.

Regards,
Vlady