Three arguments from two Column in one formula

Len Cun

New Member
Joined
Jul 17, 2018
Messages
11
Please help.

This is the scenario:
Column A-refers to employment status(pro by/regular/separated)
Column B-refers to active(true/false)
Column C-i want to display here:
If A="proby" or "separated"; C must display "Rcvng only"; if A="regular" C must display "suspension" and if B="true" C must display "suspension"; B="false" C must display "rcvng only"

Is this possible?looking forward for your kind response...

Thanks in advance!
Len
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Would have been easier if you had posted a small sample of your data and expected output. I think the below will work:
=IF(OR(A1={"proby","separated"},B1="false"),"Rcvng only",IF(OR(A1="regular",B1="true"),"suspension"))
 
Upvote 0
Some questions arise but does this look right?


Book1
ABC
1Employment StatusActiveResult
2probyTRUErcvng only
3probyFALSErcvng only
4probyrcvng only
5regularTRUEsuspension
6regularFALSEsuspension
7regularsuspension
8separatedTRUErcvng only
9separatedFALSErcvng only
10separatedrcvng only
11TRUEsuspension
12FALSErcvng only
13rcvng only
Sheet1
Cell Formulas
RangeFormula
C2=IF(OR($A2="proby",$A2="separated"),"rcvng only",IF($A2="regular","suspension",IF($B2=TRUE,"suspension","rcvng only")))


WBD
 
Upvote 0
Hello and welcome to the board, try this, but from the explanation not sure about some orders of how you want the arguments:

=IF(OR(A1={"proby","separated"},B1="FALSE"),"Rcvng Only",IF(OR(A1="Regular",B1="TRUE"),"suspension",""))
 
Last edited:
Upvote 0
Thanks WBD!

Yes,that's the outfit I want to have,except for the:
A=regular and B=false; C=Rcvng Only.

I'm gonna try all your suggestions tomorrow.
Thank you so much for your reply.

Len
 
Upvote 0
Thanks Neil, I will try this tomorrow. I'm sorry I wasn't able to show an example,actually I'm not sure if my post will get an answer,but i am very thankful that you and the other s have replied.thanks so much.
 
Upvote 0
Sorry for the unclear query.
Column A and B are fixed values.
Column C must display the "rcvng only' or "suspension" words based on the mentioned conditions.

I am very thankful for your warm welcome and replies.

Len
 
Upvote 0
Column A and B are fixed values.
Column C must display the "rcvng only' or "suspension" words based on the mentioned conditions.

Len

I may still not be clear, but this?:

=IF(AND(OR(A2={"proby","separated"}),B2=FALSE),"Rcvng Only",IF(AND(A2="Regular",B2=TRUE),"suspension",""))
 
Last edited:
Upvote 0
I may still not be clear, but this?:

=IF(AND(OR(A2={"proby","separated"}),B2=FALSE),"Rcvng Only",IF(AND(A2="Regular",B2=TRUE),"suspension",""))

Hi Joyner,

This already worked. Thanks so much! I just inserted Rcvng only instead of "" in the last condition, and it worked.thanks so much! :)

Len
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top