making a formula case sensitive

[icylemontea]

Is there a way to get excel to recognise case in a formula?

Eg: if I want =IF(C5="R","TRUE","FALSE") and I only want TRUE to appear if C5 is R but FALSE if C5 is r.

Thanks!

[teylyn]

Hello,

try

=IF(EXACT(B5,"R"),"TRUE","FALSE")

cheers

[icylemontea]

Thanks!
Worked perfectly.

[waqifktk]

niceeeeeee