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

 

[Len Cun]

Also, what will be the formula if i also want to add another condition that all dates occurring from january 2018 backwards will also be displayed as rcvng only?
Looking again for your kind responses. thanks!

code

Emp No.

Emp. Name

Date Hired

Employment Status

Position - HRIS

Position - Opns

Current Location - Opns

Active - Opns

Date of Summary Encoding

Type

Nature of Offense

Date Comitted

No. Of Offense

Penalty

Ca-000302

MJ1004

MONTERONA, RANDY GINO

10/15/2010

Regular

DRIVER

DRIVERS

CALOOCAN

TRUE

12/01/2017

Minor

Not entering SM term

05/29/2017

2nd

suspension

Ca-000303

MJ1004

MONTERONA, RANDY GINO

10/15/2010

Regular

DRIVER

DRIVERS

CALOOCAN

TRUE

12/01/2017

Minor

Not entering SM term

06/05/2017

3rd

suspension

Ca-000340

OE1701

OFIANGGA, CHRISTIAN FERDINAND DEL MUNDO

05/29/2017

Separated

CONDUCTOR

DISMISS

FALSE

12/06/2017

Grave

IBO

08/29/2017

2nd

Rcvng Only

Ca-000050

AG1404

APONGOL, REYNAN MANANSALA

04/15/2016

Regular

CONDUCTOR

CONDUCTORS

CALOOCAN

TRUE

12/06/2017

Grave

IBO

05/31/2017

1st

suspension

Ca-000052

AG1404

APONGOL, REYNAN MANANSALA

04/15/2016

Regular

CONDUCTOR

CONDUCTORS

CALOOCAN

TRUE

12/06/2017

Minor

Unauthorized discounts

06/22/2017

2nd

suspension

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Joyner]

You are welcome

Will that condition be he first one to test?

Which date / what column?

Also - make sure you do not post real data - you may not have but just making sure

 

[Joyner]

Also, do you really want to have a hard coded date (January 2018) or do you really want something like:
If the date is 180 days less than today
Or, is the date less than January of the current year

 

[Joyner]

If you wanted something like a date 180 before today, youcould use something like this where column D has the date, change as needed:

=IF(D2<=TODAY()-180,"RcvngOnly",IF(AND(OR(A2={"proby","separated"}),B2=FALSE),"RcvngOnly",IF(AND(A2="Regular",B2=TRUE),"suspension","RcvngOnly")))

Based on what you have so far, I’m not sure you couldn’thave just:

=IF(D2<=TODAY()-180,"RcvngOnly",IF(AND(A2="Regular",B2=TRUE),"suspension","RcvngOnly"))

 

[Len Cun]

Also, do you really want to have a hard coded date (January 2018) or do you really want something like:
If the date is 180 days less than today
Or, is the date less than January of the current year

The column under prev. Served must be the first reference to test. Bec. If it has a value more than zero,it is considered active.

As for the date,actually,all summary date which are 6months old from must be marked as inactive..

Thanks again..