[Solved] IF(AND) arguments

[Shawn85206]

I'm trying to get a sheet to tell me if a cell is between two values found in other cells. I want it to give me a value of 1 if true, and zero if false. Another function calculates the total score. This is the current formula.

=IF(AND(D7>D2;D7<E2)1,0)

Cell D7 has the value to be tested, D2 has the low limit, E2 has the high limit. If the value in Dt meets the hi/low limits, I want a value of 1, else a value of zero.

I've tried it with and without parenthesis around the 1 and zero, but both ways give me an Err:508. What am I missing here???

It feels like it should be super straightforward.

[FJCC]

Use semicolons between all arguments.
=IF(AND(D7>D2;D7<E2);1;0)

[RusselB]

As FJCC stated, you need to use the semi-colon between your arguments,
That aside, the main reason that you're getting an error is that there's no separator (semi-colon (as used in OpenOffice) or comma (as used in M$Excel)) between the closing parenthesis if the AND and the 1 for the TRUE return value.

[Shawn85206]

Thank you so much!