How do I hide the #DIV0! statement in a cell?
wrote in message
If you are working in Excel 2007 or later and the workbook will not be
used in Excel 2003 and earlier versions, you can use the new IFERROR
function:
=IFERROR(A1,"")
This will work only in Excel 2007 and later. It accomplishes the same
thing as the formula above. If A1 is any error, an empty cell is
displayed. If A1 is not an error, its contents are displayed.
On Sat, 25 Jul 2009 06:59:01 -0700, JSN
wrote:
Trying to make a spreadsheet more presentable by removing the #DIV0!
statements which result in formulas with 0 or no values.
Dear Chip Pearson,
what happens, when in A1 is a Formular? (In my example the Formular is in
the place Q1, and the formular is: (P1*(A1/100))+A1))
Lets think about it like that:
=IF(ISERROR(((P1*(A1/100))+A1),IF(ERROR.TYPE(Q1)=2,"",Q1),Q1) (I have
absolutely no idea if this here is correct, new area for me here...)
Do you have an idea how to figure this out?
I would be very happy!
Thanks
As Chip Pearson suggested, since 2007 use =IFERROR(value, value_if_error).
Not sure I follow your formula but maybe this is what you want
=IFERROR((P1*(A1/100)+A1),"")
Regards,
Peter T
|