Hi,

i already have a formula and need to add a condition to this formula.

The formula that i already have is =IF(($AG$1+X4)>T4,($AG$1+X4),T4)

Now i have list of 7 words in coloumn K. eg : Open,closed, hold, cancelled, On boarded, Available, Not available.

This is what i am trying to do :

If cell K2 is equal to "Open" or "closed" or "hold" or "cancelled" or "On boarded", follow the original formula =IF(($AG$1+X4)>T4,($AG$1+X4),T4).
and if cell K2 is equal to "Available" or "Not available" copy the content from different cell "R2".

Please help