MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula


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:

=IF(B2=0;"";IF(A2=0;"";B2/A2))

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
=IF(B2<>0,IF(A2<>0,B2/A2,""),"")
Probably a more efficient formula available, but this should work.
Richard