We help IT Professionals succeed at work.

Excel: If data present then put $

Pancake_Effect
on
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!
Comment
Watch Question

Commented:
Does this do what you want?

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

Lee
SANTABABYSoftware Professional
CERTIFIED EXPERT

Commented:
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)<>"","$","")

Author

Commented:
Exactly what I needed, thanks!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.