Help required with formula to find status based on different columns

[ajinkya deshmukh]

Hello All,

I need some help with formula to find out status based on the dates available in either of columns.

If data is available in Approved column then status should be approved despite dates available in Reject columns.

Or if date is available in any of the reject columns (no date in approved column) then status should appear as Reject

I have attached a sample with example (Column A to E).

Columns I to M - status as what is actually required.

Let me know if anything is unclear.

Regards
Ajinkya

 

[Hui]

In E2:
=IF(ISNUMBER(D2),"Approved",IF(ISNUMBER(A2),"Reject",""))
Copy down

 

[Somendra Misra]

In E2 and copy down:
=IF(ISNUMBER(D2),"Approved",IF(MAX(A2:C2),"Reject",""))

Regards,