S

#### Spreadsheet Geek

I want text, numbers, dates etc. to populate, but if a cell is blank, I want

a blank cell left in the cell.

I have always used =if([Wksht1]Input.xls!A1="","",[Wksht1]Input.xls!A1).

This seemed to work fine in Excel 2003. In Excel 2007 it works fine in the

sheet that the formula resides, but calculations based on the first sheet

return errors. The error is occurring because the calculation is not seeing

blanks, but "".

As an example: A second sheet has the formula in a cell

=(Input!$A1+(Input!$B1*Input!$C1/1000))

When I Evaluate the formula, I get =(""+(""*""/1000)), which returns #VALUE!.

I really do not want to go into the second 80 Meg (in Excel 2007), 400 Meg

(in Excel 2003) spreadsheet and add conditionals to all the formulas (40

Pages, at least 100 columns per page, 700 rows of data), to ignore the ""

entries, so the math works throughout the spreadsheet.

Is there a setting, or another way (without Macro's) that I can get a blank

cell out of a formula?

Thanks