| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DIsplay a value of the cell calculation is #N/A
I have numerious calculations occuring in cells. Many times if certain values
cannot be calculted, #N/A appears. I would like the field to display "Null" or "Nothing" if the error appears. How can this be done? I want a different display instead of #N/A. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel can I display a cell based on a calculation (eg M(14/2)? | Excel Programming | |||
| Can I display a cell based on a calculation (eg M(14/2)? | Excel Worksheet Functions | |||
| Save cell display but not calculation | New Users to Excel | |||
| Using rounded numbers for display, but not for the calculation. | Excel Discussion (Misc queries) | |||
| IF formula to display a product of a calculation | Excel Programming | |||
Threaded Mode
