| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display a "0" when #N/A appears in formula
When working with a formula at returns a #N/A I would like it to display a
"0" instead |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display a "0" when #N/A appears in formula
=IF(ISNA(formula),0,formula)
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "DarnTootn" wrote in message ... When working with a formula at returns a #N/A I would like it to display a "0" instead |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display a "0" when #N/A appears in formula
Thank you for your help... it works for me... can't believe I had forgotten
that formula... anywho, thanks again "Peo Sjoblom" wrote: =IF(ISNA(formula),0,formula) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "DarnTootn" wrote in message ... When working with a formula at returns a #N/A I would like it to display a "0" instead |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display a "0" when #N/A appears in formula
Try
=IF(ISNA(your formula),0,your formula) "DarnTootn" wrote: When working with a formula at returns a #N/A I would like it to display a "0" instead |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If..display "0", if greater than... display actual | Excel Discussion (Misc queries) | |||
| Display thrid letter formula | Excel Discussion (Misc queries) | |||
| Search and Display Formula | Excel Discussion (Misc queries) | |||
| Formula is entered but will not display result | Excel Worksheet Functions | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Hybrid Mode
