- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Calculation Problem

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!

- Calculation Problem posted by JohnK on Fri, 31 Oct 2003
- Re: Calculation Problem posted by Ron Rosenfeld on Fri, 31 Oct 2003
- Re: Calculation Problem posted by Phobos on Fri, 31 Oct 2003
- Re: Calculation Problem posted by HarlanĀ Grove on Sat, 01 Nov 2003
- Re: Calculation Problem posted by Dana DeLouis on Sat, 1 Nov 2003