| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas blanks vs zeros
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formulas blanks vs zeros
Try
=IF(A2="","",A2) replace A2 with your data that returns zero for blanks, you probably used 0 instead of "" -- Regards, Peo Sjoblom "Dallasbutterfly" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avoid plotting refferanced blanks as zeros in scatter plot graphs | Charts and Charting in Excel | |||
| Vlookup blanks = zeros | Excel Discussion (Misc queries) | |||
| What formula is used to replace blanks in spreadsheet with zeros? | Excel Worksheet Functions | |||
| selecting cells which contain formulas but return blanks | Excel Discussion (Misc queries) | |||
| Blanks chart as zeros | Charts and Charting in Excel | |||
Linear Mode
