IF and ELSE in excel

> enter image description here

Value1   Value2    Color
2        16        =IF(A2>5,"Red", IF(AND(5>A2>1,40>B2>1,"Yellow")),IF(AND(5>A2>1,40>B2>60,"Red")),IF(AND(5>A2>1,60>B2>100,"Yellow")),"Green)

The logic for which, I believe is:

If "Value1" > 5 ---> "Red"

If "Value1" is between 1-5 and "Value2 " is between 1-40 ---> "Yellow"

If "Value1" is between 1-5 and "Value2 " is between 40-60 ---> "Red"

If "Value1" is between 1-5 and "Value2 " is between 60-100 ---> "Yellow"

Else ---> "Green"

I want the color «red», «yellow» og «green» to be shown in a column based on two values from two different colums. I’ve tried to look it up but I can’t find anything to make my formula work. Hope the picture explains

It only says that the formula is wrong but I can’t figure out what to do…

=IF(A2>5, "Red", IF(AND(A2>1, B2>1, B2<40), "Yellow", IF(AND(A2>1, B2>40, B2<60), "Red", IF(AND(A2>1, B2>60, B2<100), "Yellow", "Green"))))

or use this

=IF(OR(B2>=100, A2<=1), "Green", IF(OR(A2>5, 60>B2>40), "Red","Yellow"))

Try this:

=IF(AND(A2<=5,B2<100,B2>60),"Yellow",IF(OR(A2>5,AND(B2>=40,B2<60)),"Red","Green"))

(Edited as I hadn't realised the mid-range for Value2 in 40-60 was to go red)

Rather than use (to me anyway) the confusing 1>x>100 way of expressing a range, I've instead put range boundaries as separate conditions within an AND clause. It's no better or worse, but I find it easier to parse that way.

thanks for the feedback! And sorry for posting the question in a wrong «format», will do better next time.
The formula that worked for me in excel is: (i am writing this from my phone so sorry for any code block errors and such)

    =IF(A2>5; «Red»; IF(AND(1<A2;A2<5;1<B2;B2<40); «Yellow»; IF(AND(1<A2;A2<5;40<B2;B2<60); «Red»; IF(AND(1<A2;A2<5;60<B2;B2<100); «Yellow»; «Green»))))