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
 
Back
Top