Hello NARAYANK991,
Thanks for your reply,
I have attached the example condition list file, when I using below If statement, Limited condition only applicable. but need above 30 conditions.
=IF(AND(A1="E",A1=S),"12",IF(AND(A1="E",A1="M"),"3",IF(AND(AH="C"),"6",IF(AND(AH=""),""))))
Please...