IF + AND formula help

BobBridges · #4 06-11-2014, 06:53 AM

David, I agree with gebobs' diagnosis—that is, your IF formula does this:

Code:

       If          Then display
I2 is N/A                H2
H2>0 and I2<0            0
H2<0 and H2+I2<0         I2
else                   H2-I2

In your original post you described what you want and it's somewhat different. But maybe that doesn't matter; instead, tell me how it isn't working. What about the results don't you like?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Help	withersd46260	Excel	2	04-30-2014 08:33 AM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM
help with formula?	doczilla	Excel	2	09-25-2011 04:14 PM
PMT Formula	OneOleGuy	Excel	4	03-05-2011 09:54 AM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM