Blanks as a condition of a statement
 

How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1:
IF b1 is not blank then add b1-c1 else don't do anything in
a1.
I have tried but can't get anything to go.
Thanks in advance,
Lee

Blanks as a condition of a statement
 

=IF(B1<"",B1-C1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


<Stuck on Blanks wrote in message news:4383062f.5bc.41@news2...
How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1:
IF b1 is not blank then add b1-c1 else don't do anything in
a1.
I have tried but can't get anything to go.
Thanks in advance,
Lee

Blanks as a condition of a statement
 

Thanks, it worked very well. Again thank you.
Lee
"Bob Phillips" wrote in message
...
=IF(B1<"",B1-C1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


<Stuck on Blanks wrote in message news:4383062f.5bc.41@news2...
How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1:
IF b1 is not blank then add b1-c1 else don't do anything in
a1.
I have tried but can't get anything to go.
Thanks in advance,
Lee