Percentage with a zero involved
PS....
I wrote:
=if(B1=0,1,C1/B1)
and
=if(B1=0,"",C1/B1)
Works just fine when B1=0.
I should have said: works just fine in Excel 2003.
If there is a version of Excel in which that does not work, I'd like to know
about. But I'd be very surprised because the paradigm above is so very
common in Excel.
----- original posting -----
" wrote:
"Shane Devenshire" wrote:
Hi Joe,
But if B1 = 0 then he gets the #Div/0! error.
So what's your point?
I wrote:
=if(B1=0,1,C1/B1)
and
=if(B1=0,"",C1/B1)
Works just fine when B1=0. Perhaps you should try it before posting
criticism.
Be sure to post back with the results of your experiment with my formula.
|