View original (French)

How to automatically insert emojis

Solved
lmorea -  
 Bearer -
Hello,
I want to automatically insert smileys using a formula in Excel.
That is to say, if the result is good = smiley face, bad = grimacing smiley...

Thank you for your solutions.

Sincerely
Configuration: Windows 2000 Internet Explorer 6.0

2 réponses

Réponse 1 / 2
michel_m Posted messages 18903 Registration date   Status Contributeur Last intervention   3 320
 
Hello

you set the cell to Wingdings font:

"J" smiling face
"K" neutral
"L" unhappy

IF(A1<10;"J";IF(A1<20;"K";"L"))

since it's very small you set it to the desired font size
--
Michel
33
Antonio
 
comment faire un smiley avec le clavier
0
Bearer
 
Thank you
0