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