how do I get formulas to recognize case sensitive text
 

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

how do I get formulas to recognize case sensitive text
 

give an example of what you want.


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


--


Gary


"okiebears" wrote in message
...
I am looking for a way to get formulas to recoginze case sensitive test

how do I get formulas to recognize case sensitive text
 

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?

"Gary Keramidas" wrote:


give an example of what you want.


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


--


Gary


"okiebears" wrote in message
...
I am looking for a way to get formulas to recoginze case sensitive test

how do I get formulas to recognize case sensitive text
 

=EXACT(A15,"A")

--
HTH

Bob

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

"okiebears" wrote in message
...
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?

"Gary Keramidas" wrote:


give an example of what you want.


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


--


Gary


"okiebears" wrote in message
...
I am looking for a way to get formulas to recoginze case sensitive test