You need to supply a fixed number, either the unit cost OR the case
cost. Excel can't calculate either without a fixed reference of some
type.

A1=case qty. (fixed number)
B1=unit cost (fixed number)
C1=case cost (=A1*B1)


--OR--

A1=case qty. (fixed number)
B1=case cost (fixed number)
C1=unit cost (=B1/A1)

--OR--

A1= case qty. (mandatory fixed entry)
B1= unit cost (optional fixed entry or left blank)
C1= case cost (optional fixed entry or left blank)
D1= calculated case cost (formula: =IF(B1="","",A1*B1)
E1= calculated unit cost (formula: =IF(C1="","",C1/A1)

Do any of these work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475518