Excel Formula

100Kay · Mar 11, 2009

So far my formula says:

If(B16=5,550)

How do I incorprate an "or" phrase to say If (B16 or B20 =5, 550)

Thanks

Niek Otten · Mar 11, 2009

=IF(OR(B16=5,B20=5),550,"What now?")

Your formula is incomplete; what if neither is 5?