Dear Sir,
Thank you for your response.
But My query is " If A3=1 & B3=1 then the result should be 1.
Likewise in all the 25 conditions (C3=1,C4=3,C5=6) etc.
Can you please help me with the formula ?
Example formula i applied - =(IF(AND(U5>=1,V5<=1),"1",IF(AND(U5>=1,V5<=2),"3", IF(AND(U5>=1,V5<=3),"6", IF(AND(U5>=1,V5<=4),"10",IF(AND(U5>=1,V5<=5),"15", (After this its not calculating) IF(AND(U5>=2,V5<1),"2".
Attached Excel sheet for your reference.
Regards,
Pradeep Moharana