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
