IF FUNCTION

0

I want to have the checkmark show up if the level is chosen from the dropdown in columnb. Then have the rest of the cells show up blank if that level is not chosen.

I've tried several different ways I cannot get it right. Is this the correct function?

Answer
Discuss

Answers

0
Selected Answer

Try this formula below in C4. Then copy down and across.

=IF($B4=C$3, "P","")

The cells must be formatted as General and the Wingdings2 font.

Discuss

Discussion

brilliant, thank you again! 
heather00 (rep: 10) Mar 1, '19 at 11:42 am
how do I count the number of check marks in the column? used counta and that was a no go.
heather00 (rep: 10) Mar 1, '19 at 11:43 am
COUNTIF should work (looking for the "P")
Variatus (rep: 2613) Mar 1, '19 at 8:40 pm
Oh that worked! THANK YOU!
heather00 (rep: 10) Mar 4, '19 at 3:57 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login