Between numbers formula

[midwest trader]

Hey everyone,
Im struggling to get a between formula to work on open office. In cell L2 I have the value of 45.
This value can and will change constantly. I would like my formula to express that if L2 is between 50 and 80 then 2 if not then 0. Here are the formulas Ive been trying.
=IF(AND(L2>=50;L2<=80;2;0)) I keep getting false for the answer instead of 0
=if(and(50>=L2<=80;2;0)) I keep getting err:509

If anyone has a solution that would be great!

Tanner

[martindwilson]

there is a seperate sub forum for open office but ill fire mine up to see whats happening

[judgeh59]

try this

=IF(AND(L2>=50,L2<=80),2,0))

I guess I just thought the syntax would be the same for the Open Office version of Excel

[martindwilson]

=IF(AND(L2>=50;L2<=80);2;0) you are missing the closing ) of the AND bit

[midwest trader]

Thank you very much, that was it!

If I wanted the same cell l2 to either determine 1 if it is less than 50, 2 if it between 50 and 80, and 4 if its 80+. How would I do all that in one formula?

[martindwilson]

=IF(l2<50;1,if(L2<=80);2;4))