Forum Discussion
Solved
IF Function
I am trying to use an IF function that looks at words rather than numbers. I would like the function to look at the data range B4:B20 and if they all have Yes typed in I would like the function to display "Certified" and if they don't all say "Yes," for example one might say "No," I want it to return "Training Needed." Can I do this? I tried the function =IF(B4:B20="Yes", "Certified", "Training Needed") but it comes back with a #value error. What would be the easiest way to accomplish this?
Hi
=IF(COUNTIF(B4:B20,"Yes")=ROWS(B4:B20),"Certified","Training needed")
3 Replies
- Thank you that worked! I would also like to make them colored. If it returns Certified, can it automatically turn the box green and if it returns Training Needed, can it turn the box red?
Change the fill color of the cell to green.
Apply a new rule for conditional formatting.
Instead of A (in this example) type Trainig needed and set the format to fill color red.
Of course you can also do it the other way round.
Hi
=IF(COUNTIF(B4:B20,"Yes")=ROWS(B4:B20),"Certified","Training needed")
