IF statements OR

[Ellasheba]

Hello

I have a worksheet that I want to add a formula to which will project dates based on a wording in a particular column.

So I have =IF(B2="One week",A2+7) or =IF(B2="Two weeks",A2+14) or if B2="One Month" then =EDATE(A2,1) or if B2="Three Months" then =EDATE(A2,3)

How can I include all the statements so the formula looks for each event and changes the date accordingly?

If there is a particular function I should be looking at can I be pointed in the right direction?

I have tried searching but cannot find exactly what I have described above
Many thanks

 

[pecoflyer]

Perhaps =IF(B2="One week",A2+7,IF(B2="Two weeks",A2+14, if (B2="One Month",EDATE(A2,1),if (B2="Three Months" ,EDATE(A2,3),""))))
( I hope there are enough closing parenthesis)
(not very elegant solution I'm afraid)

 

[Ellasheba]

Thank you I will try the above. Is this called a nested IF function?

 

[Ellasheba]

Perhaps =IF(B2="One week",A2+7,IF(B2="Two weeks",A2+14, if (B2="One Month",EDATE(A2,1),if (B2="Three Months" ,EDATE(A2,3),""))))
( I hope there are enough closing parenthesis)
(not very elegant solution I'm afraid)

It has worked perfectly and does exactly what I needed - thank you

 

[pecoflyer]

Thank you I will try the above. Is this called a nested IF function?

That is correct. It can be avoided in some cases using LOOKUP functions
You're welcome