Forum Discussion
Getting functions to recognize symbols.
The check mark that I am using in the cell to signify completed work is
ü |
The checkmark text that appears in the text entry field above the worksheet is actually a lower case u with two dots above it. I think it corresponds with the checkmark symbol in wingding font (Wingding 252).
The function that I originally came up with was =IF(Insulation!I50=Coatings!I39,"Complete",""). This works if there are only two cells that i want to compare. Unfortunately I need for it to compare 3 or more cells. It also returns the "Complete" result if all the cells are empty which makes them equal but is not the result I am looking for.
What I eventually ended up doing was creating a separate sheet in my workbook and performing some of the functions there.
It was probably the long way around to get what I needed out of the spreadsheet.
I have much to learn about Excel