how to combine 3 conditions in one formula?

Len Cun

New Member
Joined
Jul 17, 2018
Messages
11
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
 
Last edited:

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,875
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

New Member
Joined
Jul 17, 2018
Messages
11
d must be tagged as "served with pending"; the condition under column C must be first met. :)
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,875
How about =IF(C1>0, "served with pending",IF(OR(B1="rcvng only", A1<=DATEVALUE("1/31/2018')),"inactive","for sched")
 

Forum statistics

Threads
1,084,878
Messages
5,380,415
Members
401,673
Latest member
Ali Balleya

Some videos you may like

This Week's Hot Topics

Top