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
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw