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

give an example of what you want.


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


--


Gary


"okiebears" <(E-Mail Removed)> wrote in message
news:16907D07-A40F-48C5-A048-(E-Mail Removed)...
>I am looking for a way to get formulas to recoginze case sensitive test

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" <(E-Mail Removed)> wrote in message
> news:16907D07-A40F-48C5-A048-(E-Mail Removed)...
> >I am looking for a way to get formulas to recoginze case sensitive test
>
>
>

=EXACT(A15,"A")

--
HTH

Bob

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

"okiebears" <(E-Mail Removed)> wrote in message
news:6E4D5C6B-3E13-4C99-B932-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:16907D07-A40F-48C5-A048-(E-Mail Removed)...
>> >I am looking for a way to get formulas to recoginze case sensitive test
>>
>>
>>