Formula for Cases=144 * # of Cases + Pieces

  • Thread starter Thread starter Inventory Formula
  • Start date Start date
I

Inventory Formula

I'm trying to find a formula for inventory but the # of Cases & the # of
Pieces are different for each product
 
Based on your subject line, if the number of cases was in A1, and the number
of pieces in A2, the formula would be:
=a1*144+a2

If this isn't what you are looking for post back with more information.

Regards,
Fred
 
Don't have enough information to help you yet (but making some guesses)

Assuming that case numbers are in column B and piece numbers are in C
and the the 144 isn't always the same and that information is in column A

Then in column D have the equation =A1*B1+C1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
Actions recommended formula 4
Add/Subtract columns from tab to tab in same file 3
Help with SMALL formula. 12
Finding Data 2
Rank based on category 3
Excel Formula Help 1
Custom Calculation in a Pivot Table 1

Back
Top