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