< Go Back

Validate input with check mark

How To Confirm An Input With A Tick Character

If you want to confirm an input in Excel with a tick character, you can use a basic formula and fonts like Wingdings 2. What is the usefulness of this?

  • The tick or check mark character is great for managing long lists.
  • The COUNTIF function can be used to count the number of cells within a range that meets a given condition.

In this example, the “IF” and “COUNTIF” functions are used. The COUNTIF function will help us to know if the Name in Cell F8 is within the ACCEPTED Name range that we curated.

Basic formula-   =IF(COUNTIF(I8:I11, F8), "P", "") If the “IF” statement is TRUE, a Capital P shows up. If the “IF” statement is FALSE, a “” shows up.

Step 1

Type your data into the spreadsheet as shown below

Figure 1- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 2

Let us get interested in JOAN. Click on INSERT on the taskbar and then SYMBOL.

Figure 2- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

I have selected this –

Now, click on INSERT and CLOSE. You will have the next figure below.

Figure 3- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

 

Step 3

Now, input the following into the fx bar. =IF(COUNTIF(

Step 4

Highlight the names under the section captioned NAME RANGE as shown in the figure below.

Figure 4- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Highlight JOAN on Cell F8 or type F8 on the fx bar as shown below.

Figure 5- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 5

Figure 6- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Close the bracket and what you should have in the fx bar finally should be the basic formula below.

Basic formula-   =IF(COUNTIF(I8:I11, F8), "P", "")

When you hit the ENTER BUTTON, you will have the next figure.

Figure 7- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

Step 6

Can you see the tiny stuff that I circled in figure 7 above, we are going to simply double-click on it and see what happens.

Figure 8- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

 

Now, highlight Cells G8-G11. Click on the Home tab, go to font type and click on WINGDINGS 2.

The selected tick character shows up as seen below.

Figure 9- HOW TO CONFIRM AN INPUT WITH A TICK CHARACTER USING THE COUNTIF FUNCTION

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar