| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
|
#6
|
|||
|
|||
|
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? |
|
#7
|
|||
|
|||
|
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? |
|
#8
|
|||
|
|||
|
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? |
|
#9
|
|||
|
|||
|
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? |
|
#10
|
|||
|
|||
|
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? |
|
#11
|
|||
|
|||
|
"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 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a reference to lookup and insert a name | New Users to Excel | |||
| Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
| insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| Challenging Charting | Charts and Charting in Excel | |||
Linear Mode
