MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Denny Ross on February 05, 2002 1:13 PM

If I am dividing one cell by other(B2/A2)and the percent answer is going into C2 for instance. If I don't have any values in B2 or A2 how do I make C2 blank. Right now I have 0% in that cell.

Posted by Helen on February 05, 2002 1:58 PM

You need to add an IF statement to tell it that if either of the blank cells are 0 then make it blank:

Formula in cell C2:


That way you are saying if either A2/B2 are blank, then out blank.

Hope this helps you out.

Posted by Richard S on February 05, 2002 2:00 PM

In C2
Probably a more efficient formula available, but this should work.