Excel - IF conditions

janeadam 1 Posts Monday November 27, 2017Registration date November 27, 2017 Last seen - Nov 27, 2017 at 09:18 AM - Latest reply: Mazzaropi 1652 Posts Monday August 16, 2010Registration dateContributorStatus December 15, 2017 Last seen
- Nov 27, 2017 at 01:08 PM
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.
See more 

1 reply

Reply to this topic
Mazzaropi 1652 Posts Monday August 16, 2010Registration dateContributorStatus December 15, 2017 Last seen - Nov 27, 2017 at 01:08 PM
0
Helpful
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
Respond to Mazzaropi