PC Doctor June 15, 2018

Have your computer questions answered here! Search the PC Doctor archive or submit a question of your own at info@athollibrary.org

Dear PC Doctor:

I know you can use formulas in Excel to do the math for you, but I haven’t figured out how it works. Can you spell it out for me?



Dear Calculating:

Formulas are a wonderful work-saving feature of Excel! To create one, open your Excel worksheet. Select the cell that you want to put the answer in. Type the equal sign (=). Type the letter and number of the cell that you want to be the starting point for the formula. (For example, A1 or E17.) Type the mathematical symbol that represents what you want to do. (For example, if you are going to add cells, type +; for multiplication, use *; ) Then type the letter and number of the next cell that you want included in your formula. When you press Enter, Excel will do your math for you.

If you are interested in creating more complicated formulas, you can visit gcflearnfree.org or support.office.com/en-us/excel. Both have tutorials and instructions for a variety of Excel features.

Until next time,

Happy Computing!

PC Doctor