December 6, 2021
My manager called on the telephone, asking for the total sales of a particular product. I need to quickly find a total. Is there a faster way than entering a formula?
December 3, 2021
I’ve seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.
December 1, 2021
How can I create easier-to-understand formulas?
November 30, 2021
All of a sudden, the column letters along the top of my spreadsheet have been replaced by numbers. None of the formulas I enter will work. What’s wrong?
November 29, 2021
It is a pain to type the dollar signs in complex formulas such as the formula in the previous topic. How can I make this job easier?
November 26, 2021
The VP of sales in my company has dreamt up the most convoluted sales plan in the history of the world. Rather than just paying the reps a straight commission, this plan involves paying a base rate and a 2% bonus based on the product sold, and a monthly profit sharing bonus. For the spreadsheet below, I need to create a formula that can be copied to all rows and all months.
November 25, 2021
I want to create a multiplication table to help my kids in school. I want to be able to enter a single formula in cell B2 that I can copy to the entire table.
November 24, 2021
I have 5,000 rows of data. Each row contains a quantity and the unit price. The sales tax rate for all orders is shown in cell C1. After I enter a formula to calculate the total with sales tax in the first row, how do I copy the formula down to other rows?
November 23, 2021
I have 5,000 rows of data. After entering a formula to calculate gross profit percent for the first row, how do I copy the formula down to other rows?