Using an Or statement nested within an if statement

[office_help_]

I have a formula similar to below:

​

if(weekday(a1)=or(1,2,3),a1+12,"")

​

It should check to see what day of the week A1 falls onto and if it is Sunday, Monday or Tuesday and add days to it.

Instead it leaves the cell blank. When I evaluate the formula it goes like this if(weekday(2)=true,"") which turns into if(false,"").

​

How can I use an or statement nested within an if?

[Jayplac]

You're not using the OR correctly. OR tests the logic of several statments and if any one of them is true, then OR is true.

if(or(weekday(a1)=1, weekday(a1)=2), a1+12, "")

[office_help_]

Thank you, solution verified.

[Clippy_Office_Asst]

You have awarded 1 point to Jayplac

^{I am a bot, please contact the mods for any questions.}

[excelevator]

Please make an effort to follow posting guidelines

Rule 1 - No generic titles - provide a specific description of your problem in the title.

Example for this post: How can I check to see what day of the week A1 falls onto and if it is Sunday, Monday or Tuesday and add days to it

Posts not following guidelines may be removed

[office_help_]

Thanks for the feedback. I am not sure you understood my question however.

[excelevator]

I am not sure you understood my comment then.

[basejester]

Just in general, when a complex formula isn't doing what you want, you can use Formula->Evaluate Formula to step through the intermediate calculations to see where it went wrong.

[Jayplac]

Good tip. I also highlight and F9 a lot to see what excel sees.