I want to create the following formula, but it doesn't work.
=IF(B5=MONDAY,"12-17",IF(B5=WEDNESDAY,"12-18"))
12-17 AND 12-18 ARE DATES.
is it possible to do it another way?
Replies (2)
Please login or register to join the discussion.
Assuming
Monday and Wednesday are text, put them in quotes. I am also assuming you want "12-17" and "12-18" returned as text.
Missing an argument
In addition to what Paul has said, your second "IF" statement doesn't given the action to be taken if B5 doesn't equal "Wednesday".
After "12-18" you need a comma. What you put after that depends on what you want the result to be if B5 is neither Monday nor Wednesday.