Multiply value if data is found in a table

[Gbadd]

I have a file where I need to calculate the number of pallets stored (I have the total quantity and quantity on a pallet) but if the material number is found in a table or range I need to multiply the total number of pallets by two. How do I create a formula that will tell me the total pallets per line (simple division) and if the material number is in my table or range to then multiply the value by 2. In my image I made the calculations manually and want a formula to do it for me.

Thanks

Greg

 

[ZMyrrh]

What factor do you base multiplication on? If you were thinking about the item number I can do that. It does seem that you should have had more times 2 multiplication going on. If I'm correct just let me know and I can help with this.

 

[ZMyrrh]

For example, should the 16529605502 items also be multiplied by 2?

 

[Gbadd]

Thanks for responding and sorry I was not clear. I need a formula to give me the total pallets on hand by dividing QTY in column F by CA/PL in column D but if the Item # in column C in found in a table or range to then multiply the Total Pallets by 2. For example I want the formula to be written so the value in Total Pallets column below equals 226 since Item # 13009238091 is in my table stating the total pallets on hand needs to be doubled. The total for item 13009238091 would be 113 total pallets but since it is in my table it needs to be doubled meaning the total pallets should be 226.

Plant	Cat	Item	CA/PL	Loc	Qty	Total Pallets
1256​	CLN	13009238091​	48​	OW001	5424​	226​	=F2/D2*2

 

[ZMyrrh]

I would try this formula. Fill in the necessary information. The brackets are there just so you see what to fill in.

=IF(COUNTIF([Full "Item" Column Range],[Item # in that row])>1,[QTY for that row]/[CA/PL for that row]*2,[QTY for that row]/[CA/PL for that row])

 

[Fluff]

How about

=F2/D2*(1+(COUNTIFS(C12:C13,C2)>0))