|
How do you insert an "or" operator in an "IF" statement.
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? |
Try: =IF(OR(E7=0,F7=0),12.95,19.95)
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "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? |
You use the OR function:
=if(or(e7=0,f7=0),12.95,19.95) -- Regards, Fred "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? |
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? |
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. "Max" wrote: Try: =IF(OR(E7=0,F7=0),12.95,19.95) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "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? |
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. "Fred Smith" wrote: You use the OR function: =if(or(e7=0,f7=0),12.95,19.95) -- Regards, Fred "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? |
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? |
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" wrote: Try: =IF(OR(E7=0,F7=0),12.95,19.95) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "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? |
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. "Fred Smith" wrote: You use the OR function: =if(or(e7=0,f7=0),12.95,19.95) -- Regards, Fred "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? |
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. "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? |
"Jim C." wrote:
... 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 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com