Faysal Easy Excel

Mr. D is working in Logistic Department of a Company .  He is trying to make a formula that will show the "Product Remarks" Like below logic: Table 1: IF Statement logic According to his logic he is trying to build a formula. He tries but failed and finally asked " How to create a formula that contain a combination of aging in a cell to result as stated on Remarks? ". Also add " copy it down to the next rows that resulted the aging accordingly ." Solution: In C1 cell, enter below formula: =IF(AND(A1<=0,B1>=0),"Fast Moving",IF(AND(AND(A1>=1,A1<=5),AND(B1>=1,B1<=3)),"Slow Moving",IF(AND(AND(A1>=6,A1<=10),AND(B1>=4,B1<=10)),"Slow Moving",IF(AND(AND(A1>=11,A1<=15),AND(B1>=7,B1<=9)),"Surplus",IF(AND(A1>=16,B1>=10),"Dead Stock","Unknown"))))) The result will looks like below image: Image 1: IF Statement result