Hi all,

I am hoping you guys can help me.

I am trying to build a spreadsheet to work out the unit and case cost
easily at work.

a1= case quantity

b1= unit cost. =SUM(C1/A1)

b2= case cost. =SUM(A1*B1)

I want to be able to insert either the case cost or the unit cost. Now
I come up with circular reference and do what to do?

Please help

Regards
Ash


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