IF / AND Function for Checkbox

MichaelB

Hello,

I am struggling to get a formula to work. I have a sheet tracking vehicle hours. (hours updated automatically through API feed) and would like to have a check box selected if the vehicle hours fall within a range. (the range is between 4900 & 5000. (each row is one vehicle)

My formula is =IF(AND([Meter Reading]@row>4900)[Meter Reading]@row<5000,1)

if I simply do the below formula for the "over 4900" it works great, but to make a range of 4900 to 5000 then it becomes #UNPARSEABLE

=IF(AND([Meter Reading]@row > 4900), 1)

How should I write my formula to create the "range" required to only watch the window of between 4900 & 5000?

thank you

Jeff Reisman

I think you just need to rearrange your parentheses and add a comma. You're closing out the AND statement prematurely. The correct syntax is:

IF(AND(logical expression1, logical expression2, etc.), value if true, optional-value if false)

=IF(AND([Meter Reading]@row>4900, [Meter Reading]@row<5000), 1)

Jeff Reisman

I think you just need to rearrange your parentheses and add a comma. You're closing out the AND statement prematurely. The correct syntax is:

IF(AND(logical expression1, logical expression2, etc.), value if true, optional-value if false)

=IF(AND([Meter Reading]@row>4900, [Meter Reading]@row<5000), 1)

MichaelB

Thank you!

that was perfect. Formula works great.

Truly very much appreciated