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

[Jim C.]

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?

 

[Max]

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

 

[Fred Smith]

You use the OR function:

=if(or(e7=0,f7=0),12.95,19.95)

 

[Biff]

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

 

[Jim C.]

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.

 

[Jim C.]

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.

 

[Jim C.]

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

 

[Jim C.]

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.]

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.]

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.

 

[Max]

... Thanks for heading me in the right direction. ..

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>