formula Help
 

I am using this formulain D1 =if(a10,(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.

formula Help
 

May be this...

=IF(A1="","",A1*B1-C1)


"Frances C" wrote:

I am using this formulain D1 =if(a10,(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.

formula Help
 

Alternatively,
=IF(ISNUMBER(A1),(A1*B1)-C1,"")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Frances C" wrote in message
...
I am using this formulain D1 =if(a10,(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.