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%