Forum Discussion
Solved
IF Formula
I'm trying to use IF formula on this scenario If an item is product code : ABC, then use the quantity for product ABC to divide by 100 and if the product is not product code : ABC, then use the quan...
With this sample
first formula could be
=D3/((C3<>"LSSM-5888")+1)/100But it's much better to have helper table (on the right) with paperbags per item against code. When the formula (second table below) will be
=D10/VLOOKUP(C10,H3:$I$6,2,FALSE)Please check in attached file.
Let's say you have Product Code ABC in cell A1 and 500 in cell B1 as quantity.
The IF Formula will be thus 👇
=IF(A1="ABC",B1/100,B1/200)
The IF Formula will be thus 👇
=IF(A1="ABC",B1/100,B1/200)
Thank you for your reply. I tried, but it didn't work. Perhaps i did it wrongly.
Pls find below table. Could you assist to put in the formula for me in column "Total carton".
| Item no | Product Code | Delivery Qty | Total Carton |
| 1 | LSSM-5891 | 600 | |
| 2 | LSSM-5892 | 200 | |
| 3 | LSSM-5801 | 1800 | |
| 4 | LSSM-5888 | 400 | |
| Item 1,2 & 3 is 200 pcs of paperbags per packet | |||
| Item 4 is 100 pcs of paperbags per packet |
Thank you.