Forum Discussion
Shaneeee435
Dec 29, 2023Copper Contributor
Unicode symbol Checkmark in excel formula bar
Hello, can anyone advise how do you enter Unicode symbol Checkmark in excel formula bar? I am doing an If formula and I want to display the checkmark, but I am not able to add it.
Shaneeee435
Dec 29, 2023Copper Contributor
@Han Vogelaa , thanks.
After this, how do I get the checkmark in the formula? For eg. =IF(E7=0,"Jan 'Checkmark should be displayed here' ", "Jan")
After this, how do I get the checkmark in the formula? For eg. =IF(E7=0,"Jan 'Checkmark should be displayed here' ", "Jan")
HansVogelaar
Dec 29, 2023MVP
Start entering the formula without the = at the beginning.
You can then activate the Symbol dialog and insert the check mark.
At the end, insert = at the beginning.