Simple IF formula returning incorrect value

[jdr88]

Hey all!

First post here...

I'm having a hard time trying to figure out why a simple IF formula is returning an incorrect value - it's providing the total opposite of what it should be.

I've attached a picture of what I'm seeing and the formula - you should be able to see from that which value it should be pulling... The formula in the formula bar is in cell E1

If I put this data in a brand new sheet, it returns the correct value. Starting a new sheet isn't an option, really either...

Any ideas? I'm pulling my hair out!

IF Error.JPG

Thanks in advance!

[samba_ravi]

I think there might be unnecessary spaces in B1 or D1 use below
=If(TRIM(D1)=TRIM(B1),C2,C1)

[jdr88]

I think there might be unnecessary spaces in B1 or D1 use below
=If(TRIM(D1)=TRIM(B1),C2,C1)

You, sir, have just saved me so much time!

... and most likely my hairline. Thanks so much!