Previous Topic Next Topic

Excel - IF conditions

Closed
janeadam Posts 1 Registration date Monday November 27, 2017 Status Member Last seen November 27, 2017 - Nov 27, 2017 at 09:18 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 27, 2017 at 01:08 PM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses