[SOLVED] 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

=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

Thanks, it worked very well. Again thank you.
Lee
"Bob Phillips" <[email protected]> wrote in message
news:OB9yb%[email protected]...
> =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
>
>