IF + AND formula help

		Microsoft Office Forums > Microsoft Excel > Excel
IF + AND formula help

FAQ

Thread Tools

Display Modes

06-10-2014, 03:48 PM

gebobs

Windows 7 64bit IF + AND formula help

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Quote:

Originally Posted by david_89_

=IF(ISNA(I2),H2,IF(AND(H2>0,I2<0),0,IF(AND(H2<0),( H2+I2)<0),I2,(H2-I2)))

What this will do is...

IF I2=NA() THEN H2
ELSEIF H2>0 AND I2<0 THEN 0
ELSEIF H2<0 AND H2+I2<0 THEN I2
ELSE H2-I2

I'm not surprised it doesn't work. :-)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:57 PM.