inventory formulas
Wow, thanks!!!!!!!
"JMB" wrote in message
...
You won't be able to combine the Case Price and Units Per Case. Excel
will
treat this as text and your formulas won't work. If we have 5 columns
Column A - Item Description
Column B - Quantity
Column C - Case Price
Column D - Units Per Case
Column E - Inventory Value
A2 = Tomatoes
B2 = 4
C2 = 25
D2 = 5
In cell E2 type
=C2/D2*B2
then select cell E2, click on the black cross in the bottom right corner
of
the cell and drag your mouse down as far as you need to go. Be sure not
to
combine text with your numbers as Excel will treat the entire thing as
text
instead of numeric data. Of course, if Column D is 0, you will get a
divide
by 0 error in Column E. To clean this up you can change the formula to
=IF(D2=0,"",C2/D2*B2)
|