Excel Formulas to Show Checkmark for Valid Inputs ~ Simple Tutorial!!

A Tick mark can be inserted into a cell to convey the result of “yes” as an answer to some questions. In this tutorial, we will learn about how to use the IF function to put the checkmark for valid inputs in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• To show the checkmark for the result, you can use the below formula.

=IF(A1=”complete”,CHAR(252),””)

Syntax Explanations:

• CHAR – This function is used to get a character by a specified number. Read more on the CHAR function.
• IF – In Excel, the IF function helps to return one value for a TRUE result, and another for a FALSE result.
• Value A1- It represents the input value of the cell.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

• Here we will enter the input values in Column B and Column C.

• Then apply the above-given formula to the formula bar section, and press the “Enter” key.

• Finally, it will display the result as shown below.

Note : The cells in Column E must be formatted with the “Windings” font for this to work.

Conclusion:

Hope you like this article on how to use the IF function to put the checkmark for valid inputs in Excel. If you have any doubts , don’t forget to share them with us. To learn more, check out Geek Excel *and Excel Formulas *!!

Read Ahead:

• Excel Formulas: IF Function with Wildcard Characters!!
• Excel Formulas to Test If a Cell Value is (X or Y) and Z!!