IF Formula replacement instead of using EXACT

[Beh162]

I have an IF formula I've been using that uses EXACT function in it, so anytime something was in CAPS and it matched a cell it would come back with a 2. If it matched but wasn't caps it would be 1. Then those numbers would be tallied.

I wanted to see if maybe there was another array I could use instead. I wish it would work with formatting where I could set up a conditional format where the CAPS would be rather than manually typing it caps, but I'm aware it doesn't.

IF(OR($S$3=""),"",IF(AND(K3="Push",$S$3="Push"),3,IF(AND(K3=$S$3,EXACT(K3,$S$3)),1,IF(K3=$S$3,2,0))))

background info:
It's a list of teams and you select one team as your "best bet" and if you get that right you get an extra point. I've been using CAPS to signify the best bet and the formula would return 2 points if it matched S3 and was caps.

 

[Beh162]

If changing K3 on demand to capitals is tiring, put a tag in a satellite cell like K2 in order to mark the entry in K3 as best bet. And modify the formula to work with that tag.

Thanks I’ll give this a try !