# 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
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Use this formula...And format the cell as % to show the % to it...

=IFERROR(B10/B11,0%)

Saurabh...

Experts Exchange Solution brought to you by