Thread: [Solved] IF + AND formula help
View Single Post
 
Old 06-10-2014, 01:03 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by david_89_ View Post
-if H2<0 and H2+I2<0, return H2
IF Condition THEN Result ELSE Alternative

You've given the Condition and the THEN Result but not the Else Alternative

Quote:
-if H2<0 and I2 is N/A, return H2
What is the relationship between the equations? Are they OR or AND? Or is the second equation the ELSE Alternative for the first?
Reply With Quote