Formula required to combine multiple results through IF or other solution

[chullan88]

Hi,

I have three values A,P,W which can produce the following results:

1.) A < P - should display " Delayed Plan"
2.) A < W - should display "Delayed Workflow"
3.) A >= P - should display " On Schedule"
4.) A >= W - should display " Proper Workflow"

I have noticed that given any set of values, two of these conditions will always be met.I want to combine these results and get them in a single cell.

Attached worksheet for reference.


Thanks in advance.

[avk]

Try with

Please Login or Register  to view this content.

[FDibbins]

Have not looked at your file, but based on the formula provided by avk, that could maybe be simplified to this?
=IF(or(D2<=D3, D2<=D4), H3&" & "&H4, IF(D2>=D3, H5&" & "&H6, " "))

[samba_ravi]

try
=MID(IF(D2<D3," & "&H3,"")&IF(D2<D4," & "&H4,"")&IF(D2>=D3," & "&H5,"")&IF(D2>=D4," & "&H6,""),4,512)

[chullan88]

Hi all, thanks for the replies

But none of the solutions work for the following set of values: A=1,P=9,W=1

[Bo_Ry]

Is this right?

=IF(D2<D3,H3,H5)&" & "&IF(D2<D4,H4,H6)