In this article, we will learn how to find average sales totals by day of the week in Microsoft Excel 2010. To find the average sales total by part...
To find a formula that will retrieve the output by rounding numerical substrings to 3 decimal places, we will use a combination of LEFT, FIND, MID &am...
Problem: Calculating the credit that remains after each purchase is made. Once the credit limit (stored in cell B1) is exceeded, zero is to be ret...
Problem: List1 (column A) contains 10 numbers, two of which (0 & 500) are significantly smaller or greater than the remainder. If included in ...
Problem: The following PMT formula calculates the monthly payment for a $100,000 mortgage, repaid over a period of 20 years, at 8% annual interest:...
Problem: The range B2:G6 contains some of the following parameters for a number of different loans (each occupying a separate column): Principal, ...
Problem: Columns A & B contain a log of all the sales from a particular day. Each row consists of the name of an item and the quantity sold. ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
