getting XL to recognize lower from upper case in IF formula
On Thu, 06 Dec 2007 16:35:32 -0500, stef wrote:
Excel 2002 SP3
Win XP Pro SP2
*Follow-up to: microsoft.public.excel*
Hi,
I have an IF formula where =IF(LEFT(D3,3)="ABc",(B3*C3)/50,B3*C3)
When LEFT(D3,3)="ABC", unfortunately, it seems XL does not see the
difference between the lower case "c" in former example and upper case
"C" in latter example.
Is it me?
Can I get around this?
=IF(EXACT("Abc",LEFT(D3,3)),(B3*C3)/50,B3*C3)
--ron
|