IF and OR Combo

[carl]

I would like to write a formula that will:

If A3=O OR A4>25 then A1+A2 otherwise do nothing.

Thank you in advance.

 

[DDM]

Carl, here you go:

=IF(OR(A3="O",A4>25),A1+A2,"")

If O is in fact 0 [zero] leave out the quotes.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Frank Kabel]

Hi
one way:
=IF(OR(A3="O",A4>25),A1+A2,"")

 

[Jason Morin]

Do you mean a zero?

=IF(OR(A3=0,A4>25),A1+A2,"")

Or if you really mean the letter "O":

=IF(OR(A3="O",A4>25),A1+A2,"")

HTH
Jason
Atlanta, GA

 

[Pete JM]

Hi,


=IF(OR(A3=0,A4>25)=TRUE,A1+A2," ")


Pet