If statement (2003)

Topic

New Reply

How do I say this in excel-ese? If the difference between A2 and B2 is a negative number, do nothing, if A2 contains text, do nothing, otherwise subtract the two cells.

Thank you in advance!
Deb

Reply | Quote

Replies

How about? (I presumed by “difference” you meant A2-B2 and not B2-A2)
=IF(ISTEXT(A2),””,IF(A2-B2<0,"",A2-B2))

Steve

Reply | Quote

Wonderful! I learn so much from this forum…now if I could only remember everything I learn

Thanks Steve and Rudi

Reply | Quote

Try this: =IF(ISTEXT(A2),”Nothing”,IF(A2-B2<0,"Nothing",A2-B2))

Reply | Quote