Thread
:
Custom number code [conditional] help
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
Custom number code [conditional] help
Unfortunately I'm creating this for someone that wants the
cells to show a 0 "zero" not a "blank" or a "#N/A"
Why can't you do it this way then?
=IF(ISERR(YourFormula),0,YourFormula)
Rick
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)
Custom number code [conditional] help