How do I display an empty cell and calculate on it

[Dave]

I am using a reference on one sheet to fill the values in another. If a cell
has not value it I want it to be blank. But I also what it to be used in a
calculation when it is populated.

I have tried nothing, but it enters a 0, I have tried
=IF(Data!C2>0,Data!C2,""), =IF(Data!C2>0,Data!C2,null),
=IF(Data!C2>0,Data!C2,isnull) but each has it's own problems.

Is there a way to make a cell empty and calculate on it while referencing
another sheet?

Thanks

Dave

 

[Fred Smith]

The standard way is as follows:
=if(data!c2="","",yourcalculation here).

If you need more help, tell us what "problems" you are having, and the
solution you are looking for.

Regards,
Fred

 

[Dave]

I fixed it using formatting.

Dave