How to change value in a cell based on multiple conditions

Hi All,

In the attached excel file, Column C changes its status to Not Available if the value in Column D is Do Not Disturb and also based on other few criteria from another sheet.

I have added a column E with drop down as Out Of Office.

I want to retain the existing formula and also want to add an additional formula to the existing one such that if Column E contains Out Of Office, then the status in column C should be Not Available

In other words, if any one column either D or E are selected with the option from drop down, then the status in column C should be Not Available.

Note: Existing formula needs to be retained.

Can someone help with both the formulae in a single cell?

Thanks in advance.

Hi TMS,

Thank you for your prompt response.

However, as mentioned earlier, there is already a formula existing in column C. I would like to retain this existing formula and add the new condition to the same formula.

Can you help me with the combination of both formulae.

Thank you.

Oh this was it !!

I was trying to enter whole formula again and it wasn't working.

Thank you so much TMS.