I need a formula that will breakdown an original number with two components
into multiple components which then add up to the original. The example
below was generated with straight original x %, which ended up generating a
$0.01 difference. I need the broken up figures to add up to the orginal to
the penny. Thanks for your help!
$5,475.00 + $273.75 = $5,748.75
28.55% = $1,563.11 + $78.16 = $1,641.27
24.42% = $1,337.00 + $66.85 = $1,403.85
19.25% = $1,053.94 + $52.70 = $1,106.64
13.95% = $763.76 + $38.19 = $801.95
13.83% = $757.19 + $37.86 = $795.05

100.00%= $5,475.00 + $273.76 = $5,748.76 ($0.01 too much)