| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OR function problem
I'm trying o figure out why this formula isn't working as expected.
I need to check in a column to see if any cells have the number zero or #NA. If either condition is true, OR should return "True" and then make the destination cell blank. If neither condition is met then OR returns "False" and the value from F11 is copied to G11. This formula is in cell G11: =IF(OR(ISNA(F11),F11=0),"",F11) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With IF Function | New Users to Excel | |||
| Problem with function | Excel Discussion (Misc queries) | |||
| Function problem | Excel Worksheet Functions | |||
| Problem with IF function | Excel Worksheet Functions | |||
| FV Function Problem | Excel Worksheet Functions | |||
Threaded Mode
