Excel 2007 : Returning wrong value with IF function

**bdinsdale** · 06-27-2011, 03:04 PM

I have two separate functions I am using in different cells but in the same column. I L17 cell I am referencing contains the value 3.0. I want the first function to return the true value of 2 because the >=3 is equal to 3.0. However, the next cell down also returns its true value of 1 even though I specified only to return 1 if it is <3, not <=3.

=IF(L17>=3,2,0) --- returns 2 correctly

=IF(OR(L17>1,L17<3),1,0) --- returns 1 (wrong!)

Please help!

Thank you!

**arthurbr** · 06-27-2011, 03:11 PM

Is the value in L17 a number or a string looking like a number?

**scottylad2** · 06-27-2011, 03:12 PM

If the value in L17 is 3.0, the first argument in the Or part of your =IF(OR(L17>1,L17<3),1,0) is correctly going to return 1 as 3.0 is greater than 1. The Or function is basically saying if argument 1 is TRUE OR argument Two is TRUE, return 1.

What you have is correctly showing 1. If you need it to show something else then maybe it needs to showL17=1 or something?

**bdinsdale** · 06-27-2011, 03:18 PM

authorbr, L17 is just the value 3.0 manually entered.

Scottylad2, thanks to your response, I figured out that it should be an AND function instead of OR. My hard copy document I was referring to had OR incorrectly written in the cell instead of AND.