Forum Discussion
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 quantity for that product to divide by 200.
How do i do that formula using IF?
thank you
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.
7 Replies
One more variant is =Qty/((Code="ABC")+1)/100 or with cell references
=B1/((A1="ABC")+1)/100Thanks Sergei.
I am not that familiar with IF Formula.
Can you put it in full formula as i tried the formula you gave but it didn't work out.
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)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.
