Is this possible ?

[Steakman]

I was wondering if it is possible to do the following in Excel, and if so,
where I can find out how ?

I am producing a Management Report for all levels of staff and would like
the report to do the following:
eg
If cell A1> 10, then in cell A2 display a "smiley face"
If cell A1=10, then in cell A2 display a "neutral face"
If cell A1 < 10, then in cell A2 display an "unhappy face"

It would be great if the "faces" could be in colour (green. amber, red), and
I presume they would need to be an image i.e giff file. - Making the images
is easy, but doing a formula is beyond me!

Anyone got any help or suggestions.

Thanks

Andre

 

[RagDyer]

Enter this formula into A2:

=IF(A10>10,"J",IF(A10=10,"K","L"))

Then, format A2 to the WingDings font.

This will give you a sad face even when A10 is empty (<10).

If you want A2 empty when A10 is empty, try this:

=IF(A10>10,"J",IF(A10=10,"K",IF(A10="","","L")))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I was wondering if it is possible to do the following in Excel, and if so,
where I can find out how ?

I am producing a Management Report for all levels of staff and would like
the report to do the following:
eg
If cell A1> 10, then in cell A2 display a "smiley face"
If cell A1=10, then in cell A2 display a "neutral face"
If cell A1 < 10, then in cell A2 display an "unhappy face"

It would be great if the "faces" could be in colour (green. amber, red), and
I presume they would need to be an image i.e giff file. - Making the images
is easy, but doing a formula is beyond me!

Anyone got any help or suggestions.

Thanks

Andre

 

[Harald Staff]

Hi Andre

Fun idea and very simple to do. No images needed. Formula in A2:
=CHAR(74+(A1<=10)+(A1<10)+(A1<=5))
Format the cell with font "Wingdings" and there you are.

(The last part
+(A1<=5)
displays a bomb if the value is 5 or below. Remove it if you hate it.)

Coloring is a little worse, but far from impossible. Use Conditional formatting for that
(Format menu).

 

[Steakman]

Thanks for all your help.

Now I have something to do this weekend !!

Andre

 

[Ken Schmidt]

That is so cool Harald! Very clever little formula. Thank you.

Ken