John Sheehy
asked on
Showiing a zero percentage
I have three cells, B3, B4, and B5. They are formatted as number. B5 formula is like this =sum(B3:B4)
Since B3 and B4 both contain a zero B5 number is zero as well.
Cells B10 and B11 are formatted as percentages. B10 formula is this: =sum(B3/B5) and B11 formula is this: =sum(B4/B5)
Since B3 and B4 have 0s in them B10 and B11 give me a div/0 error.
How do I get B10 and B11 to display a 0%
Thanks
John
Since B3 and B4 both contain a zero B5 number is zero as well.
Cells B10 and B11 are formatted as percentages. B10 formula is this: =sum(B3/B5) and B11 formula is this: =sum(B4/B5)
Since B3 and B4 have 0s in them B10 and B11 give me a div/0 error.
How do I get B10 and B11 to display a 0%
Thanks
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In mathematics, division by zero is undefined, so to display 0% is incorrect.
ASKER
That worked perfect, thank you
ASKER
Really quick answer