G
Guest
I am using this formulain D1 =if(a1>0,(a1*b1)-c1,"") and it works fine
becuase the formula unless there is a number in cell a1 it will not show. And
that is the way I wanted.
But my problem is that when I have a 0 in a1 and a 0 in b1 and a 0 in c1, I
do not get any results in D1. sometimes I have to enter zeros but I need the
result to be zero as well.
becuase the formula unless there is a number in cell a1 it will not show. And
that is the way I wanted.
But my problem is that when I have a 0 in a1 and a 0 in b1 and a 0 in c1, I
do not get any results in D1. sometimes I have to enter zeros but I need the
result to be zero as well.