Calculating cells blanks

C

cootz

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
 
C

cootz

Thanks...it works!!

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

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

--
Regard
Frank Kabe
Frankfurt, German

cootz wrote
 
Top