Link to home
Start Free TrialLog in
Avatar of John Sheehy
John SheehyFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
In mathematics, division by zero is undefined, so to display 0% is incorrect.
Avatar of John Sheehy

ASKER

That worked perfect, thank you
Really quick answer