Three arguments from two Column in one formula

[Len Cun]

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

 

[njimack]

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"))

 

[wideboydixon]

Some questions arise but does this look right?

Book1
	A	B	C
1	Employment Status	Active	Result
2	proby	TRUE	rcvng only
3	proby	FALSE	rcvng only
4	proby		rcvng only
5	regular	TRUE	suspension
6	regular	FALSE	suspension
7	regular		suspension
8	separated	TRUE	rcvng only
9	separated	FALSE	rcvng only
10	separated		rcvng only
11		TRUE	suspension
12		FALSE	rcvng only
13			rcvng only
Sheet1

Cell Formulas
Range	Formula
C2	=IF(OR($A2="proby",$A2="separated"),"rcvng only",IF($A2="regular","suspension",IF($B2=TRUE,"suspension","rcvng only")))

WBD

 

[Joyner]

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",""))

 

[Len Cun]

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

 

[Len Cun]

Output* I mean..just using mobile phone right now.hehe
Thanks again.

 

[Len Cun]

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.

 

[Len Cun]

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

 

[Joyner]

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",""))

 

[Len Cun]

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