C
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.
If A3=O OR A4>25 then A1+A2 otherwise do nothing.
Thank you in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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
=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
F
Frank Kabel
Hi
one way:
=IF(OR(A3="O",A4>25),A1+A2,"")
one way:
=IF(OR(A3="O",A4>25),A1+A2,"")
J
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
=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
P
Pete JM
Hi,
=IF(OR(A3=0,A4>25)=TRUE,A1+A2," ")
Pet
=IF(OR(A3=0,A4>25)=TRUE,A1+A2," ")
Pet