Solved

Excel: If data present then put $

Posted on 2012-03-13
3
261 Views
Last Modified: 2012-06-21
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!
0
Comment
Question by:Pancake_Effect
3 Comments
 
LVL 13

Accepted Solution

by:
lee555J5 earned 500 total points
Comment Utility
Does this do what you want?

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

Lee
0
 
LVL 10

Expert Comment

by:SANTABABY
Comment Utility
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
 
LVL 4

Author Closing Comment

by:Pancake_Effect
Comment Utility
Exactly what I needed, thanks!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now