Excel - IF conditions

Closed
Report
Posts
1
Registration date
Monday November 27, 2017
Status
Member
Last seen
November 27, 2017
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hi All,
I am trying to create a formula to show the outcome of a status based on 4 conditions.

1. IF cell A2 = Approved and B2 = Approved then C2 = Approved
2. IF cell A2 = Approved and B2 = Pending then C2 = Pending
3. IF cell A2 = Approved and B2 = Rejected then C2 = Rejected
4. IF cell A2 = Rejected and B2 = Rejected then C2 = Rejected.

Any help is much appreciated.

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
janeadam, Good afternoon.

Try to use:

=IF(A2="Approved",IF(B2="Approved","Approved",IF(B2="Pending","Pending",IF(B2="Rejected","Rejected",""))),IF(A2="Rejected","Rejected",""))

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão