Excel Forum
Similar Content
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Excel Prank - Automatically Change User-Entered Text
Tutorial: Use AutoCorrect to change the text a user enters into something funny. This is a great lit...
Remove Gridlines in Excel 2007 and Later
Tutorial: In Excel 2007 and later you can quickly remove the gridlines that appear within the Excel ...



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.