if function with text

if function with text

Didn't find your answer?

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.

avatar
By paulwakefield1
07th Jul 2012 10:02

Assuming

Monday and Wednesday are text, put them in quotes. I am also assuming you want "12-17" and "12-18" returned as text.

Thanks (0)
avatar
By sarahf
08th Jul 2012 11:52

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.

Thanks (0)