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
"Biff" wrote:
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." <Jim wrote in message
...
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?
|