Forum Discussion
Support with If Function
Hello All, I have written below if function to derive the payment type for vendors. I am stuck with one condition. If my column "I" is blank and if my column "C" is not equal to "C" or "K" then t...
Hi,
Perhaps something like this
=IF(OR(RIGHT(TRIM(C2),1)="9",
RIGHT(TRIM(C2),1)="X"),"No Pay Run",
IF(AND(TRIM(I2)="",
LEN(TRIM(C2))=1,
OR(TRIM(C2)<>"C",
TRIM(C2)<>"K")),"MDI",
IF(OR(TRIM(C2)="GM"),"IC Pay Run",
IF(OR(RIGHT(TRIM(C2),1)="T",
RIGHT(TRIM(C2),1)="U"),"F",
IF(OR(RIGHT(TRIM(C2),1)="C",
RIGHT(TRIM(C2),1)="D",
RIGHT(TRIM(C2),1)="P",
RIGHT(TRIM(C2),1)="Q",
RIGHT(TRIM(C2),1)="E",
RIGHT(TRIM(C2),1)="B",
RIGHT(TRIM(C2),1)="X",
RIGHT(TRIM(C2),1)="S",
RIGHT(TRIM(C2),1)="K"),"D","MDI")
))))
if not simplify the rest
- Thank you Sergei Baklan
Regards,
Chandrakanth.K
