Hello there,

I am relatively new to writing Excel formulas & have done a lot of Googling, but I can't figure out how to write a formula that will do this.

If A1 <=8 AND B1 <=3, return "Lesson 1"
If A1 >=9 AND B1=4, return "Lesson 43"
If A1 >=12 AND B1=5 AND C1 = 10-14 AND D1 = 5-9, return "Lesson 61"
If A1 >=14 AND B1=5 AND C1=15 AND D1=10 AND E1 = 12-15 AND F1 <=3, return "Lesson 73"
If A1 >=19 AND B1=5 AND c1=15 AND D1=10 AND E1 = 16-18 AND F1 = 4-6, return "Lesson 97"

If you can help me write this, you are going to be my hero!

Thank you in advance.

Odette