| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical test for an #N/A condition in a cell
I have a VLOOKUP that returns a dollar value from another spreadsheet. If an
entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
| IF functionality, Logical Test = Nonbalnk Cell | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| =IF logical test to search only part of a cell | Excel Worksheet Functions | |||
Threaded Mode
