How do you insert an "or" operator in an "IF" statement.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to create an IF statement where one cell or a second cell or both cells
equal zero and if true it reports one value and if false gives another value.
I tried the following formulas and did not get a numeric value:

=IF(E7=0"or"F7=0,12.95,19.95)
=IF(E7"or"F7=0,12.95,19.95)

Can anyone tell me how to correctly enter the formula?
 
Hi!

Try this:

=IF(OR(E7=0,F7=0),12.95,19.95)

However, this does not account for empty cells. If one or both cells are
empty the formula will still return 12.65. Is that what you want?

Biff
 
Your fix worked if both E7 and F7 were >0. I need it to work when only one
or both are >0. When both E7 and E8 = 0 the formula gave the correct
response 12.95.

Thanks for your time. If you have any other suggestion, please forward.
 
The formula only worked when E7 and F7 = 0 or both were > 0. I needed it
also to work when either E7 or F7 > 0 and the value should be 19.95.

Thanks for your suggestion. If you have any ideas for the 19.95 value to
appear when either E7 or E8 or both are >0 please let me know.
 
The formula only worked when E7 and F7 = 0 or both were > 0. I needed it
also to work when either E7 or F7 > 0 and the value should be 19.95.

Thanks for your suggestion. If you have any ideas for the 19.95 value to
appear when either E7 or E8 or both are >0 please let me know
 
I used your formula but changed the operator from "OR" to "And". It worked.
Why it worked, I am not sure since "OR" seemed to be what logic would expect.

Thanks for heading me in the right direction.
 
I used your formula but changed the operator from "OR" to "And". It worked.
Why it worked, I am not sure since "OR" seemed to be what logic would expect.

Thanks for heading me in the right direction.
 
I used your formula but changed the operator from "OR" to "And". It worked.
Why it worked, I am not sure since "OR" seemed to be what logic would expect.

Thanks for heading me in the right direction.
 
Jim C. said:
... Thanks for heading me in the right direction. ..
Click to expand...

You're welcome !

Glad you were able to tweak the suggested formula to suit,
albeit I must say your orig. post as it stood, points to the use of OR() <g>
 
Back
Top