Multiple If Statement

[cartica]

Hi-

My current statement works below, but I would like to add some more logic, just not sure how.

Please Login or Register  to view this content.

I would like to add below. Is there a way to combine both statements?

Please Login or Register  to view this content.

Thanks

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[mcmahobt]

If both of these formulas are to be applied to the same cell, try this:

Please Login or Register  to view this content.

Will something like that work?

[cartica]

Thanks Guru. The below Works. One more question. I know that Workday (F2,1) denotes next working day from cell f2. Instead of having the 0 after it, how can I change to say that if it's not

Please Login or Register  to view this content.

then just come back with the exact date in F2.

Please Login or Register  to view this content.

[TMS]

You mean:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[cartica]

Thanks. Last Question on this I promise! Can I add to below down the line. So, let's say I wanted to look at multiple names in D2. Example: I wanted to look at "CEMAR", or "Corp" instead of just "CEMAR", and the rest of formula still applies.

Please Login or Register  to view this content.

[TMS]

Last answer. Promise.

Please Login or Register  to view this content.

Regards, TMS