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 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor 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
    1. Antonio
       
      comment faire un smiley avec le clavier
      0
    2. Bearer
       
      Thank you
      0