IF/AND function

[mjanovit]

<TABLE width="100%"><TBODY><TR><TD>
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!

</TD></TR></TBODY></TABLE>

 

[kpark91]

=IF(AND(a=b, c=d,e=f), "True", "False")

 

[mjanovit]

I apologize, part of my example formula was cut off. This is the first of four nested IFs...

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