Excel Forum

Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies

See how to allocate $950 across 7 days including the extra penny with a single formula. Meldoc and mikerickson from the Mr Excel Message Board provide a great formula that uses SUM, ROUND and ROWS functions. Accounting Allocating costs.
Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.