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.