Showing zero % when dividing 0 into 0

    I have a column where I'm dividing one cell by another. At times both of these cells will have zero data. How can I get the result to post as 0%?
    Thank you

    Re: Showing zero % when dividing 0 into 0


    =IF(B2=0,0,A2/B2)


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

    Re: Showing zero % when dividing 0 into 0


    That worked! I was trying to be too fancy within the formula. I feel a bit stupid, but with a happy look on my face :) Thank you very much.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login