Empty (blank) cell read as zero??

[patamills]

I am using the formula *9/5+32 to change celsius values on on
worksheet to fahrenheit on another linked sheet. This works OK, bu
all the unentered (blank) cells on the celsius sheet appear as 32 o
the fahrenheit sheet until values are entered on the C sheet. Untidy!
Is there a way of keeping cells on both sheets blank until entries ar
made on the C sheet

 

[Frank Kabel]

Hi
try somehing like
=IF('sheetC'!A1="","",'sheetC'!A1*(9/5)+32)

 

[Pete McCosh]

You could use an IF to trap the empty cell on the other
sheet:

=if(IsBlank(C!A1),"",C!A1/9*5+32)

Cheers, Pete.

 

[Peo Sjoblom]

=IF(A1="","",A1*9/5+32)

there is also a built in function if you have the ATP installed

=IF(A1="","",CONVERT(A1,"C","F"))