Hi,

I have a column(A) which has figures and blank entries.

In column(B) im using the =whatever is in column(A).

In column(B) it is returning the answer as 0 if column(A) is blank. But i want it to return blank if column(A) has a blank not a 0.

Can you help please.

Thanks

Ru