Auto adjustment of functions
Is there any way for formulas to self-adjust? I'm doing a worksheet for savings. IE: Item A gets 10%, Item B gets 40%, Item C gets 15%, Item D gets 15% Item E gets 30%. If $100 is saved so far: Item A is up to $10, B is $40, C is $15, D is $15 And E is $30. If item B's goal is $15 with the rest still needin to accrue, is there any way to automatically have the formula stop contributing to Item B and split the rest to the other items? I know this would be fairly complex.
Thanks for any help!
|