On Wednesday, February 29, 2012 8:30:08 AM UTC-6, gfy532 wrote:
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!

At least show us your formula or send a file to dguillett1 @gmail.com





--
gfy532