Displaying a % as a number
To avoid % sign for zeros..Use the same formula with ISERROR and custom
format the cell to
0.00%;-0.00%;0
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
Handle the error using ISERROR()
=IF(ISERROR(O1/P1),0,O1/P1)
If this post helps click Yes
---------------
Jacob Skaria
"michael walker" wrote:
Hi, First post. I have 2009 sales data in column O and 2008 sales data column
P and the the following formula in column Q = O1/P1 as have formatted it as a
% to show an increase or decease
When the sales data in column o is 0 and p is 0 the result is #DIV/0!
When the sales data in column o is 0 and p is 0 the result is a %
I want the workbook to display a % when column o is 0
If both 0 & P are 0 i want a 0 to be displayed
I appreciate you help
Thanks
Michael
|