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!
LVL 4
Pancake_EffectAsked:
Who is Participating?
 
lee555J5Commented:
Does this do what you want?

=IF(ISBLANK(A1),"","$")

Lee
0
 
SANTABABYCommented:
Just in case you have whitespace character(s) in the cells and want them to be treated as blank cells, use the following formula for row 1 and then copy it down to other rows.

=IF(TRIM(A1)<>"","$","")
0
 
Pancake_EffectAuthor Commented:
Exactly what I needed, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.