formulas blanks vs zeros

D

Dallasbutterfly

I have to convert Excel worksheets into format readable by Access. My only
problem now is between the two worksheets. When pulling data from one, using
formulas, when there is a blank instead of a number the spreadsheet pulling
the data places a "0" instead of leaving blank. I have tried to write an IF
statement but that then changed not only my blanks but when I had a "0" it
left it blank. Can someone help me?
 
P

Peo Sjoblom

Try

=IF(A2="","",A2)


replace A2 with your data that returns zero for blanks, you probably used 0
instead of ""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help in fine-tuning a formula that removes blank cells in a column range 3
Publisher is filling blank lines with data 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Return BLANK is cell value sought is blank 13
Having Blank Cells, etc. ? 1
how to insert serial numbers to rows? 3
Sumproduct - Return value as Blank 3
Using COUNTA and excluding formulas that gives zero or blank cells 3

Top