Copy empty cells from one worksheet to another

[David Cohen]

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

 

[Jim Rech]

A formula must always have some value and the "" your formulas return is
technically a null string. You cannot make a formula return "nothing". So
you must adjust your statistical formulas to account for this (if possible)
or bring your data together by copy/pasting rather than by formula.

--
Jim
| 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
|
|