how do I get formulas to recognize case sensitive text

[okiebears]

I am looking for a way to get formulas to recoginze case sensitive test

 

[Gary Keramidas]

give an example of what you want.


=IF(LOWER(A1) = "test",1,0)

 

[okiebears]

I am trying to write a formula that will give the probability of color based
on sire and dam

the variables are A,a,-, G, g, - , I need to get excel to recognize the
lower case text, is this doable?

 

[Bob Phillips]

=EXACT(A15,"A")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)