Calculation Problem

Giganews Newsgroups
Subject: Calculation Problem
Posted by:  Larry (lkimba…@pacbell.net)
Date: 31 Oct 2003

How can I structure the worksheet to solve this problem.  The cell
value is part of the total but the cell calculation depends on the
total.

For example:

Cell B1= 3% of cell B4
Cell B2= 5% of cell B4
Cell B3=10
Cell B4=sum(B1:b4)

How can cells B1 & B2 be calculated when they're part of the total?
Thank you!

Replies