Excel - 3 AND conditions?

August 22, 2011 at 09:02:45
Specs: Windows XP
Is it possible to have a=b and c=d and e=f within one IF statement?

This is the first part of my nested IF statement, however, I hypothetically would need another "and" variable in here to be accurate.

=IF(AND((O29+O47)>(O3-0.01),(O36+O27)<O6),((O38*O8*O24)-O48),0)

Self-taught excel user, so any insight is appreciated!


See More: Excel - 3 AND conditions?

Report •

#1
August 22, 2011 at 14:38:48
re: "Self-taught excel user, so any insight is appreciated!"

"Self-taught" should include reading the Excel Help files.

Look up the AND function in Excel Help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question