Login

  • Jul 25, 2024

Using Emojis in Excel Formulas

You can use conditional formatting to insert symbols in cells. You can also use formulas with emojis. using range names makes it even easier.

Sign up to hear about free Excel training.

I won't share your email with anyone.

To insert an emoji icon in a cell you can use press the Windows key and the full stop.

This opens the Emojis dialog box.

In this example we are going to insert three separate symbols in formulas.

I have named each cell that has an emoji. A1 = Tick, A2 = Cross and A3 = Dash.

You can use these names in formulas throughout the file.

The formula in cell F2 (Sales) is.

=IF(D2>E2,Tick,IF(D2

The formula in cell F3 (Costs) is.

=IF(D3E3,Cross,Dash))

The advantage with using formulas instead of conditional formatting is that you can format the cells. Plus using formulas in cells is easier than using formulas in conditional formats.

Naming your emojis makes then easier to use. You can use these emoji icons names in your formulas throughout the file.

0 comments

Sign upor login to leave a comment