IF AND OR - Statements

[Robert_G]

I've got my statement wrong or I'm trying to write this incorrectly.



I have two drop down lists.

M5 has 4 statements - Saturday, Sunday, Monday, Tuesday
M6 has 3 conditions - Open, Lunch, Closed

I am trying write an IF statement.

Saturday & Sunday have the same answer for Open & Lunch = 99.5 and Closed will = 99
Monday and Tuesday share the same answer if it's Open = 98 (true), and 100 (false) for the other 2 conditons






=IF(OR(M5="SATURDAY",IF(M6="OPEN",99.5,IF(M6="LUNCH",99.5,IF(M6="CLOSED",99),IF(M5="SUNDAY",IF(M6="OPEN",99.5,IF(M6="LUNCH",99.5,IF(M6="CLOSED",99))),IF(AND(M5="MONDAY",M6="OPEN"),98,IF(AND(M5="TUESDAY",M6="OPEN"),98,100)))

 

[Fluff]

How about
=IF(OR(M5={"Saturday","Sunday"}),IF(M6="Closed",99,99.5),IF(M6="open",98,100))

 

[Robert_G]

I had to adjust things but worked perfectly. Very simple.

 

[Fluff]

Glad you sorted it & thanks for the feedback