Can you help me create an Excel 2010 formula for displaying blank cells?

http://ift.tt/1iZHv9S

I need an Excel 2010 formula that

1) displays whatever the value is of a given cell but

2) if there is no value there – it displays the cell as a blank (at the moment whenver I use the “=” function for a cell that is blank, I’m getting “0.0″ in the cell I enter the formula in.

Say:

A1 is: 18500

A2 is: (blank)

________________________

What formula would I use in a different cell to display A1 & A2 respectively with A2 showing as a blank instead of 0.0?

Post and answer: Can you help me create an Excel 2010 formula for displaying blank cells?