Exact formula with small and large cap letters

[johnny52]

I got a great answer for my conditional fomat =(A1,"Rr)...thanks

now how would I get this formula to return "SO" when it meets criteria.

My formula is as follows. I want to recognize either one when it occurs in that C6 cell

=IF(OR(exact(C6,"rR"),IF(EXACT(C6,"sS"),"SO",""))

maybe I should use AND instead of OR....my results just returns VALUE

 

[dreid1011]

Your formula is not quite right, try this:

=IF(OR(EXACT(C6,"rR"),EXACT(C6,"sS")),"SO","")

The second IF() in the middle is not necessary using OR() to get the same result. If you were wanting different results based on the string, then you would nest IF()'s.

 

[Fluff]

It should be

=IF(OR(EXACT(C6,"rR"),EXACT(C6,"sS")),"SO","")

 

[johnny52]

It should be

=IF(OR(EXACT(C6,"rR"),EXACT(C6,"sS")),"SO","")

Perfect...Thanks so much

 

[Fluff]

Glad we could help & thanks for the feedback.