entering null values

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

I am trying to do a conditional statement, and I can't quite get it right.
This is my formula:
=IF(G8>8, G8-8, null)

I don't know how to leave the cell blank if the condition is false. With
the present formula I just get the "#NAME error.

Mike
 
Never mind...Solved my own problem....
Formula should be:
=IF(G8>8, G8-8, "")
Mike
 
The problem with this is that it appears to convert the cell into a text
cell.
If you then try and import that into Access (using TransferSpreadsheet)
it complains because the value is a text value (blank) rather than
null.

Any thoughts on how to get around this?

Mark
 
Jet may be determining the data type of your column incorrectly. Jet
tries to determine the data type using the the data. If it determines
the data type too hastily (e.g. thinks it is text or 'mixed types' of
numeric and text), the column may end up being imported as text.

Check the following registry settings for the machine:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows

Setting the value to 0 (zero) will force Jet to scan all column values
before choosing the appropriate data type.

Also look at:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes
 
Back
Top