| 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? |
| 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 | |||
Threaded Mode
