Basic Excel Skills – Insert a Happy Face using the IF Function

1 Flares Filament.io 1 Flares ×

I was asked today if it was possible to write an IF function that could insert a happy face if certain criteria was met. This would be used to show good performance. An unhappy face would be inserted for poor performance.

To insert a happy face in Excel we need to enter a capital J and format the cell in a Wingdings font. For an unhappy face, it’s a capital L formatted in the Wingdings font.

The following basic Excel skills demonstrates using this technique to display a happy or unhappy face dependent upon someone’s exam grade. The exam grade is in cell B3 and the smiley face will be inserted into cell C3.

  1. Click in cell C3
  2. Write the IF function below and copy it to all the cells where you want the happy face to be displayed. This will display a happy face if 75% or more has been scored.

=IF(B3>=75%, “J”, “L”)

If Function displaying a J or an L

  1. Select the cells and click the Font list arrow on the Home tab of the Ribbon
  2. Select Wingdings from the list

Format as Wingdings font

  1. Happy and unhappy faces are shown dependent on the exam grade

Smiley faces shown dependent upon criteria

Browse our website for more basic Excel skills.

Watch the Video

2 thoughts on “Basic Excel Skills – Insert a Happy Face using the IF Function

  1. I like it, Suppose you give an animation for the wingdings, I think so beautiful, Thanks once again for your good work

  2. awesome no words to appreciate well done, pls upload more this type of unique functions it will be helpfull to all

    thanks
    bharath bhushan

Leave a Reply

Your email address will not be published. Required fields are marked *