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.
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?