Formula for Cases=144 * # of Cases + Pieces

I

Inventory Formula

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

Fred Smith

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
 
B

Brad

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
 
Top