←Back to all posts
•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Help in excel to calculate pallets.

Can someone please help me. I am struggling to figure this out.

I have on one tab, my inventory and product line.

Product line determines 40 or 80 bags per pallet.

Product line when 50 I call A

Product line for 80 I call B

Product line for 40 is C

Based on inventory available in column ‘B’ I want to calculate the number of pallets available in inventory using lookup to find the product line and either divide by 40 if it’s A or 80 if it’s B etc

Can someone please help me with this?

Can someone please help me. I am struggling to figure this out.

I have on one tab, my inventory and product line.

Product line determines 40 or 80 bags per pallet.

Product line when 50 I call A

Product line for 80 I call B

Product line for 40 is C

Based on inventory available in column ‘B’ I want to calculate the number of pallets available in inventory using lookup to find the product line and either divide by 40 if it’s A or 80 if it’s B etc

Can someone please help me with this?

submitted by /u/Character_One8478
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#Excel compatibility
#rows.com
#Excel alternatives
#excel
#pallets
#product line
#help
#inventory
#calculate pallets
#calculate
#pallet size
#number of pallets
#lookup
#bags
#available inventory