Excel: If data present then put $
Posted on 2012-03-13
We have data in Column1. In Column2 we want a formula that checks to see if a cell in Column1 has data in it, if so put a $ in the cell on Column2, if not leave it blank.
We want to drag this formula all the way down in column 2 checking.
I imagine this has to be a simple formula, any help?