Conditional Statement-w/Objects

  • Thread starter Thread starter thorvision
  • Start date Start date
T

thorvision

We use scorecards quite a bit in my line of work. We often use smilely
face, and sad face to depict satisfactory financial performance. This,
however has to be done by copying the face to the cell over and over.

Can someone advise me on an easy method for setting up a conditional
statement that picks the correct face (object)based on a criterial I
set up. ex. if A1>=, $100, "smiley face", "sad face". I don't know any
VBA, but am pretty good with Excel functions.
 
Format the cell with the WingDings font, and use the following formula:

=IF(A1>100,CHAR(74),CHAR(76))

Adjust the font size as desired.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
WoW, Thanks Chip!! I was so terrified that it would require VBA. This
is the place I will go for all my Excel questions.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Southwark Park Tavern 14
Illegal Alien Stripper Uliana Abramova get out of NY out ofUSA!!!!!!!!!!!! 14
Access Conditional Relationship 2
Excel 2000 very unstable as a development environment 11
Problems Loading Large String Array into Array variable 6
What is going on? 18
Queries in VBA 6
PC Addict? 4

Back
Top