=IF(AND(B1>100,B2>100,B3>100),”Over Budget”,”Acceptable”)
Tuesday, April 2, 2013
the IF Excel Function
Nesting the AND function inside the IF function
Subscribe to:
Posts (Atom)
Excel Work Sheet Programming
=IF(AND(B1>100,B2>100,B3>100),”Over Budget”,”Acceptable”)