G Guest Mar 29, 2006 #1 My formula is as follows: =(P6/100*55-P30)/(P6/100*55)*100 I keep getting the #DIV/0! error. Can you help?
My formula is as follows: =(P6/100*55-P30)/(P6/100*55)*100 I keep getting the #DIV/0! error. Can you help?
P Pete_UK Mar 29, 2006 #2 P6 must be zero or blank. Try this to avoid the error: =IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100) Hope this helps. Pete
P6 must be zero or blank. Try this to avoid the error: =IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100) Hope this helps. Pete
G Guest Mar 29, 2006 #3 Is the value in P6 0? That would explain it, even though you have P6 in the numerator, 0/0 will still give #DIV/0.
Is the value in P6 0? That would explain it, even though you have P6 in the numerator, 0/0 will still give #DIV/0.
G Guest Mar 30, 2006 #5 It works Pete, Thank you so much. I knew someone out there had an answer for me. I am surprised that microsoft help could not assist me. Thanks again. Cindy
It works Pete, Thank you so much. I knew someone out there had an answer for me. I am surprised that microsoft help could not assist me. Thanks again. Cindy
