how to combine 3 conditions in one formula?

[Len Cun]

Please help me again.

I want to create a formulas from which the conditional statements will be coming from 3 different columns.

A1 B1 C1 D1
Encode Date Penalty Prev. issued Status

wherein Columns A,B and C must be combine in one formula to arrive at column D(this must display either inactive,for sched or served with pending)

A=date of encoding:
if date is below January 31, 2018, D1 must be tagged as "inactive"
if date is February 1, 2018 to present, D1 must display "for sched"
B=Penalty
if penalty is suspension, D1 must display "for sched"
if penalty is rcvng only, D1 must display "inactive"
C=Prev.issued (1st priority to be established)
if C is greater than zero, D1 must also display "served with pending"

simultaneous conditions, is this possible?

Thanks in advance again.

Len

 

[mikerickson]

What do you want to happen when conflicting conditions are met?

If the date in A is Jan. 1, 2017 and B has penalty in suspension and C is 12, what do you want?

 

[Len Cun]

d must be tagged as "served with pending"; the condition under column C must be first met.

 

[mikerickson]

How about =IF(C1>0, "served with pending",IF(OR(B1="rcvng only", A1<=DATEVALUE("1/31/2018')),"inactive","for sched")