Formula for Cases=144 * # of Cases + Pieces
 

I'm trying to find a formula for inventory but the # of Cases & the # of
Pieces are different for each product

Formula for Cases=144 * # of Cases + Pieces
 

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

"Inventory Formula" <Inventory wrote in
message ...
I'm trying to find a formula for inventory but the # of Cases & the # of
Pieces are different for each product

Formula for Cases=144 * # of Cases + Pieces
 

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


--
Wag more, bark less


"Inventory Formula" wrote:

I'm trying to find a formula for inventory but the # of Cases & the # of
Pieces are different for each product