empty cell

[marta]

Hello,
I have an excel worksheet that is linked to access. It is
very important that cells with zero value appear as empty
cells in my access table.
The excel column has the following formula:
=IF(ISBLANK(C4),,E4)
and it returns a zero if cell C4 is blank.
Is there any way to specify it to return an empty cell?

Thanks so much for your help!
Marta

 

[Dave R.]

I may be wrong, but I think the closest you can come is to return "" -- a
cell with a formula will NEVER be empty, because there is a formula there.

=IF(ISBLANK(C4),"",E4) may work.

I don't know how "" will be represented in Access (i.e., whether it will be
looked at the way a truly empty/blank value is). My guess is they will be
different somehow. If so, and it's feasible in your operation, you can use
something like

=IF(ISBLANK(C4),"DELETE_ME",E4)

then sort your entire range on this column, select all the cells containing
"DELETE_ME" in this column, and hit DEL to clear the cell contents, which
will make them blank/empty.

 

[marta]

excelent your first suggestion does what i need it to do
thank you!