Desplay zero if yes

Pat · Dec 10, 2004

=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains nothing
return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat

Frank Kabel · Dec 10, 2004

Hi
=IF(AND(I29-J29>0,S29,"Yes"),0,I29-J29)

JE McGimpsey · Dec 10, 2004

one way:

=IF(ISBLANK(S29),I29-J29,IF(AND(I29>J29,S29="Yes"),0,"Undefined"))

Guest · Dec 10, 2004

Should be: =IF(AND(I29-J29>0,S29="Yes"),0,I29-J29)

Ian P

Pat · Dec 10, 2004

Hello Frank,

I am getting a #VALUE! error returned.

Pat

Condition now returns error	2	Feb 20, 2005
Sumif Function	2	May 27, 2009
SUMIF?	9	Oct 13, 2008
using if/then in Word 2000 table	1	Jan 7, 2004
Identifying the # of cells containing data	3	Mar 17, 2009
IF statement value range required	2	Jan 22, 2007
To combine various cell formulae in to the final cell	1	Aug 2, 2009
formulas that may sometimes contain empty cells	2	Jan 28, 2009

Desplay zero if yes

Pat

Frank Kabel

JE McGimpsey

Guest

Pat

Ask a Question

Similar Threads