Hello,

I had a worksheet (myWorksheet) in which the user entered data - number of
vehicles.
Empty cell means there is no vehicles.

Now I get my data from different excel workbook (dataWorksheet).

I tried to use this in my worksheet cells:
=if (dataWorksheet cell value = "" , "", dataWorksheet cell value)

My problem is that in some calculations in other worksheets
I get #value or other error messages (in average calculations).

How can I set empty cell in my worksheet ?


Thank you
David Cohen