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.
RETAXES---Copy1-040211sendOnly.xlsm
1r3o2n8Asked:
Who is Participating?
 
Brian GeeConnect With a Mentor Commented:
Try this:

Tools > Options > View tab > uncheck Zero Values checkbox.
0
 
Brian GeeCommented:
Many other ways to do this as well illustrated in Office Excel 2007 help:

http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP010070461.aspx
0
 
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.

=IF(I7="","",0.5*I7)

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

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

=IFERROR(0.5*I7,"")

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

General;;;

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

=IF(IFERROR(0.5*I7,"")=0,"",IFERROR(0.5*I7,""))

cheers, teylyn

0
 
1r3o2n8Author Commented:
Such a simple, direct solution.  Thanks alot.  rgds/ron
0
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.