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
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.
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:
- Excel - IF conditions
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 27, 2017 at 01:08 PM
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
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