We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

iserror formula fails

1r3o2n8
1r3o2n8 asked
on
Medium Priority
301 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2011

Commented:
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
CERTIFIED EXPERT
Most Valuable Expert 2013

Commented:
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
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
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

Author

Commented:
Such a simple, direct solution.  Thanks alot.  rgds/ron
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.