Basic Microsoft Excel Formulas
Microsoft Excel: Can you enter a formula that will add one cell to another in a pattern w/o going cell by cell
I am completely new to Excel, and I’m trying to teach myself the basics. I have a book to guide me, but I’m finding I just find more questions than answers. So here goes…
I’m trying to write a basic spreadsheet with a few different columns to figure out how much money I’ll earn by working different hours of overtime. For example, I have a column marked “Total Hours Worked,” then “Total Gross,” “Estimate of Taxes Taken Out,” and “Total Paid.” I’m trying to figure out if there’s a way to set a formula for the first column. For example, the first entry would be 40 hours, then I want to go up in .25 increments up to 60 hours. Is there a way I can enter a formula somewhere to have Excel do it for me? Or do I have to enter the numbers line by line. It just seems so repetitive, I feel like I’m missing a shortcut.
Thanks!
What you need to do is to enter the formula into one cell. When this is done, click on the cell and you will see a small square on the lower right corner of the cell, drag it to whatever cells you want it to apply to.
|
|
Microsoft Excel Functions & Formulas $26.05 Microsoft Excel Functions & Formulas |
|
|
Formulas and Functions With Microsoft Excel 2003 $39.14 Formulas and Functions With Microsoft Excel 2003 |
|
|
Microsoft Office Excel 2007 Formulas & Functions for Dummies $21.74 Microsoft Office Excel 2007 Formulas & Functions for Dummies |
|
|
Formulas and Functions With Microsoft Office Excel 2007 $34.79 Formulas and Functions With Microsoft Office Excel 2007 |
|
|
Microsoft Excel 2007 Basic $74.99 Excel training isn’t just for newcomers to the Office suite. Anyone who uses Excel even seasoned users can increase their knowledge on their own through self-study Microsoft Excel 2007 training. |
|
|
Microsoft Office Excel 2007 Visual Basic for Applications Step by Step $26.09 Microsoft Office Excel 2007 Visual Basic for Applications Step by Step |
|
|
Excel 2007 Formulas $39.14 Excel 2007 Formulas |
|
|
Excel Formulas And Functions For Dummies $21.74 Excel Formulas And Functions For Dummies |
|
|
Excel 2003 Formulas $39.14 Excel 2003 Formulas |
|
|
Microsoft Excel 2007 - $12.99 Microsoft Excel 2007 - |
|
|
Microsoft Excel 2007 $324.68 Microsoft Excel 2007 |
|
|
Microsoft Office Excel 2007 $37.6 Microsoft Office Excel 2007 |
|
|
Vba And Macros For Microsoft Excel $43.49 Vba And Macros For Microsoft Excel |
|
|
Microsoft Excel 2010 On Demand $26.09 Microsoft Excel 2010 On Demand |