Calculating cells blanks

[Guest]

I am trying to write an "IF" formula that calculates when the cell contains info, and when blank refers to another cell for the calculation information. I keep receiving the FALSE message. What am I doing wrong

Thanks in advance

 

[Frank Kabel]

Hi
try something like
=IF(A1<>"",your calculation,other cell calculation)

 

[Guest]

Thanks...it works!!

----- Frank Kabel wrote: ----

H
try something lik
=IF(A1<>"",your calculation,other cell calculation

--
Regard
Frank Kabe
Frankfurt, German

cootz wrote