iserror formula fails

See attached workbook, RE sheet, cell L7.  I want a blank in the cell if there is no entry in tax amt. col.  I get a zero instead of blank.  Please help.  Thanks. rgds/ron.
Who is Participating?
Brian GeeConnect With a Mentor Commented:
Try this:

Tools > Options > View tab > uncheck Zero Values checkbox.
Brian GeeCommented:
Many other ways to do this as well illustrated in Office Excel 2007 help:
barry houdiniCommented:
The problem you have is that there is no error generated by 0.5*I7 when I7 is blank, it just treats I7 as a zero and the result is zero. Try explicitly returning a blank if I7 is blank, i.e.


regards, barry
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

in Excel 2007 and later, you can shorten the formula to


Also, to suppress zero values, you can use a custom format like


Or you can use conditional formatting to use the same font and background color when the result is 0.

Or you can use a formula like


cheers, teylyn

1r3o2n8Author Commented:
Such a simple, direct solution.  Thanks alot.  rgds/ron
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.