How to Multiply Numbers in Excel | multiplication excel formula[/caption]
multiplication excel formula
Excel is an abundantly able apparatus for accepting acceptation out of all-inclusive amounts of data. But it additionally works absolutely able-bodied for simple calculations and tracking about any affectionate of information. The key for unlocking all that abeyant is the filigree of cells. Beef can accommodate numbers, text, or formulas. You put abstracts in your beef and accumulation them in rows and columns. That allows you to add up your data, array and clarify it, put it in tables, and body great-looking charts. Let’s go through the basal accomplish to get you started.
[caption id="" align="aligncenter" width="400px"]
How to Multiply Numbers in Excel | multiplication excel formula[/caption]
Excel abstracts are alleged workbooks. Each workbook has sheets, about alleged spreadsheets. You can add as abounding bedding as you appetite to a workbook, or you can actualize new workbooks to accumulate your abstracts separate.
Click File, and again bang New.
Under New, bang the Blank workbook.
Click an abandoned cell.
For example, corpuscle A1 on a new sheet. Beef are referenced by their area in the row and cavalcade on the sheet, so corpuscle A1 is in the aboriginal row of cavalcade A.
Type argument or a cardinal in the cell.
Press Admission or Tab to move to the abutting cell.
Select the corpuscle or ambit of beef that you appetite to add a bound to.
On the Home tab, in the Font group, bang the arrow abutting to Borders, and again bang the bound appearance that you want.
For added information, see Administer or abolish corpuscle borders on a worksheet .
Select the corpuscle or ambit of beef that you appetite to administer corpuscle concealment to.
On the Home tab, in the Font group, accept the arrow abutting to Fill Blush , and again beneath Theme Colors or Standard Colors, baddest the blush that you want.
For added advice about how to administer formatting to a worksheet, see Architecture a worksheet.
Use AutoSum to add your abstracts
When you’ve entered numbers in your sheet, you ability appetite to add them up. A fast way to do that is by application AutoSum.
Select the corpuscle to the appropriate or beneath the numbers you appetite to add.
Click the Home tab, and again bang AutoSum in the Editing group.
AutoSum adds up the numbers and shows the aftereffect in the corpuscle you selected.
For added information, see Use AutoSum to sum numbers
Adding numbers is aloof one of the things you can do, but Excel can do added algebraic as well. Try some simple formulas to add, subtract, multiply, or bisect your numbers.
Pick a cell, and again blazon an according assurance (=).
That tells Excel that this corpuscle will accommodate a formula.
Type a aggregate of numbers and adding operators, like the additional assurance ( ) for addition, the bare assurance (-) for subtraction, the asterisk (*) for multiplication, or the advanced carve (/) for division.
For example, admission =2 4, =4-2, =2*4, or =4/2.
Press Enter.
This runs the calculation.
[caption id="" align="aligncenter" width="400px"]
Excel 2007: Creating Simple Formulas - Full Page | multiplication excel formula[/caption]
You can additionally columnist Ctrl Admission if you appetite the cursor to break on the alive cell.
For added information, see Actualize a simple formula.
To assay amid altered types of numbers, add a format, like currency, percentages, or dates.
Select the beef that accept numbers you appetite to format.
Click the Home tab, and again bang the arrow in the General box.
Pick a cardinal format.
If you don’t see the cardinal architecture you’re attractive for, bang Added Cardinal Formats. For added information, see Accessible cardinal formats
.
A simple way to admission Excel’s ability is to put your abstracts in a table. That lets you bound clarify or array your data.
Select your abstracts by beat the aboriginal corpuscle and boring to the aftermost corpuscle in your data.
To use the keyboard, authority bottomward Shift while you columnist the arrow keys to baddest your data.
Click the Quick Analysis button in the bottom-right bend of the selection.
Click Tables, move your cursor to the Table button to examination your data, and again bang the Table button.
Click the arrow in the table attack of a column.
To clarify the data, bright the Baddest All analysis box, and again baddest the abstracts you appetite to appearance in your table.
To array the data, bang Array A to Z or Array Z to A.
Click OK.
For added information, see Actualize or annul an Excel table
Appearance totals for your numbers application Quick Analysis
The Quick Analysis apparatus (available in Excel 2016 and Excel 2013 only) let you absolute your numbers quickly. Whether it’s a sum, average, or adding you want, Excel shows the adding after-effects appropriate beneath or abutting to your numbers.
Select the beef that accommodate numbers you appetite to add or count.
Click the Quick Analysis button in the bottom-right bend of the selection.
Click Totals, move your cursor beyond the buttons to see the adding after-effects for your data, and again bang the button to administer the totals.
[caption id="" align="aligncenter" width="400px"][/caption]
Add acceptation to your abstracts application Quick Analysis
Conditional formatting or sparklines can highlight your best important abstracts or appearance abstracts trends. Use the Quick Analysis apparatus (available in Excel 2016 and Excel 2013 only) for a Live Examination to try it out.
Select the abstracts you appetite to appraise added closely.
Click the Quick Analysis button in the bottom-right bend of the selection.
Explore the options on the Formatting and Sparklines tabs to see how they affect your data.
For example, aces a blush calibration in the Formatting arcade to differentiate high, medium, and low temperatures.
When you like what you see, bang that option.
Learn added about how to assay trends in abstracts application sparklines.
Appearance your abstracts in a blueprint application Quick Analysis
The Quick Analysis apparatus (available in Excel 2016 and Excel 2013 only) recommends the appropriate blueprint for your abstracts and gives you a beheld presentation in aloof a few clicks.
Select the beef that accommodate the abstracts you appetite to appearance in a chart.
Click the Quick Analysis button in the bottom-right bend of the selection.
Click the Archive tab, move beyond the recommended archive to see which one looks best for your data, and again bang the one that you want.
Note: Excel shows altered archive in this gallery, depending on what’s recommended for your data.
Learn about added means to actualize a chart.
To bound array your data
Select a ambit of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a distinct column). The ambit can accommodate titles that you created to analyze columns or rows.
Select a distinct corpuscle in the cavalcade on which you appetite to sort.
Click to accomplish an ascendance array (A to Z or aboriginal cardinal to largest).
Click to accomplish a bottomward array (Z to A or better cardinal to smallest).
To array by specific criteria
Select a distinct corpuscle anywhere in the ambit that you appetite to sort.
On the Abstracts tab, in the Array & Clarify group, accept Sort.
The Array chat box appears.
In the Array by list, baddest the aboriginal cavalcade on which you appetite to sort.
[caption id="" align="aligncenter" width="400px"]
How to multiply two columns and then sum in Excel? | multiplication excel formula[/caption]
In the Array On list, baddest either Values, Corpuscle Color, Font Color, or Corpuscle Icon.
In the Adjustment list, baddest the adjustment that you appetite to administer to the array operation — alphabetically or numerically ascendance or bottomward (that is, A to Z or Z to A for argument or lower to college or college to lower for numbers).
For added advice about how to array data, see Array abstracts in a ambit or table .
Select the abstracts that you appetite to filter.
On the Abstracts tab, in the Array & Clarify group, bang Filter.
Click the arrow in the cavalcade attack to affectation a account in which you can accomplish clarify choices.
To baddest by values, in the list, bright the (Select All) analysis box. This removes the analysis marks from all the analysis boxes. Then, baddest alone the ethics you appetite to see, and bang OK to see the results.
For added advice about how to clarify data, see Clarify abstracts in a ambit or table.
Click the Save button on the Quick Admission Toolbar, or columnist Ctrl S.
If you’ve adored your assignment before, you’re done.
If this is the aboriginal time you've save this file:
Under Save As, aces area to save your workbook, and again browse to a folder.
In the File name box, admission a name for your workbook.
Click Save.
Click File, and again bang Print, or columnist Ctrl P.
Preview the pages by beat the Abutting Folio and Previous Folio arrows.
The examination window displays the pages in atramentous and white or in color, depending on your printer settings.
If you don’t like how your pages will be printed, you can change folio margins or add folio breaks.
Click Print.
Activate and use an add-in
On the File tab, accept Options, and again accept the Add-Ins category.
Near the basal of the Excel Options chat box, accomplish abiding that Excel Add-ins is called in the Manage box, and again bang Go.
In the Add-Ins chat box, baddest the analysis boxes the add-ins that you appetite to use, and again bang OK.
If Excel displays a bulletin that states it can't run this add-in and prompts you to install it, bang Yes to install the add-ins.
For added advice about how to use add-ins, see Add or abolish add-ins.
Acquisition and administer a arrangement
[caption id="" align="aligncenter" width="400px"][/caption]
Excel allows you to administer congenital templates, to administer your own custom templates, and to chase from a array of templates on Office.com. Office.com provides a advanced alternative of accepted Excel templates, including budgets.
For added advice about how to acquisition and administer templates, see Acquisition and administer a template.
[caption id="" align="aligncenter" width="400px"]
Excel 2003: Creating Simple Formulas - Full Page | multiplication excel formula[/caption]
[caption id="" align="aligncenter" width="400px"]
Excel Sum Percentage multiply Formula - YouTube | multiplication excel formula[/caption]
[caption id="" align="aligncenter" width="400px"]
Excel 2010 Formulas And Functions | multiplication excel formula[/caption]
[caption id="" align="aligncenter" width="400px"]
Excel 2010 Matrix Multiplication (MMULT) | multiplication excel formula[/caption]
[caption id="" align="aligncenter" width="400px"]
[/caption]
[caption id="" align="aligncenter" width="400px"]
[/caption]
[caption id="" align="aligncenter" width="400px"]
Basic Excel Formulas - Add, Subtract, Divide, Multiply - YouTube | multiplication excel formula[/caption]