Pancake_Effect
asked on
Excel: If data present then put $
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?
Thanks!
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?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I needed, thanks!
=IF(TRIM(A1)<>"","$","")