If statment for three results....

Hello friends...

I am trying to write "IF" statement.... as per following logic....

1. Column A - Date of Expiry
2. Column B - NOC issued
3. Column C - Status as today (Status options, "Expired", "NOC" given and "Valid")

Condition 1: If Date is < than Date(today) then in Column C "Expired"
Condition 2: If in Column B "NOC" than in Column C "NOC" ( P.S. irrespective of Date of expiry)
Condition 3: If Date > than Date (today) then in Column C "Valid"
Condition 4: If Date > than Date (today) and in Column B "NOC" then in Column C "NOC"

=IF(1A<TODAY(),"Expired",IF(B1="NOC","NOC",IF(A1<TODAY(),"Expired","Valid")))

in above statement only two conditions are working...

Thanks in advance

Please Login or Register  to view this content.

Is this okie?

If B1=NOC, regardless what date in A1. If there is not NOC, check date. If date < today then "Expired", else if date >= today, then "Valid"