• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF statements OR

Ellasheba

Member
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
 

Attachments

  • Book1.xlsx
    9.9 KB · Views: 6
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)
 
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
 
Back
Top