three cells with multiple conditions and logic

Hi say i have cells cell “A” – with different dollar amounts cell “B” – with either L2, L3, L4 cell “C” – with Either anything from the Lists Below c.1 This can be anything from the list below which i clustered to rename the table as “LPF” Late Payment Fee LPF’s info Late Payment Waiver Fee c.2 This can be anything from the list below which i clustered to rename the table as “NLPF” Customer Satisfaction CSAT Credit Nest Waiver Fee The Logics are : 1. If there’s no amount in cell “A” then it’s “not applicable” 2.a If cell “B” contains L4 there are 2 conditions/logic a. If cell “B” contains “L4”, cell “A” contains <-25 and cell “C” says that it’s part of the “NLPF” list, then it shows “EXCEEDED” if not then it shows “NOT EXCEEDED” b. If cell “B” contains “L4”, cell “A” contains <-50 and cell “C” says that it’s part of the “LPF” list, then it shows “EXCEEDED” If not then it shows “NOT EXCEEDED” 2.b If cell “B” contains L3, cell “A” contains <-100, then it shows “EXCEEDED”, if not then it shows “NOT EXCEEDED” 2.c If cell “B” contains L2, cell “A” contains <-300, then it shows “EXCEEDED”, if not then it shows “NOT EXCEEDED” I already have the formula if cell “B” just have one condition/logic if it contains “L4” the thing is that it should contain 2 conditions plus it should consider the one written in cell “C”. I’m finding it difficult to incorporate that in my formula. Knowing that i also clustered the data in cell “C” into 2 groups. Can you help me regarding this?

 

I already have the formula if B1=”L4″,A1<-25…

 

=IF(A1>=0,”Not Applicable”,(IF(B1=”Not Applicable”,”Not Applicable”,(IF(AND(B1=”L4″,A1<-25),”Exceeded”,(IF(AND(B1=”L3″,A1<-100),”Exceeded”,(IF(AND(B1=”L2″,A1<-300),”Exceeded”,(IF(AND(B1=”L1″,A1<-300),”Exceeded”,”Note Exceeded”)))))))))))

 

But what if i need two logical conditions for

B1=”L4″, A1<-25,C1=NLPF as part of that table , and if B1=”L4″, A1<-50,C1=LPF as part of that table

 

I’ve tried to drill down the above condition using only if B1=”L4″ ,

I don’t know why if the A1<-25 and C3 a part of NLPF should use an array, while if A1<-50 and C3 part of LPF i should not use an array… =IF(AND(A1<-25,B1=”L4″,C1=NLPF),”EXCEEDED”,IF(AND(A2<-50,B2=”L4″,C2=LPF),”EXCEEDED”,”NOT EXCEEDED”))

By: Ken

Leave a Reply

Your email address will not be published. Required fields are marked *