Excel 2016 Version Number Mac Or Excel

To do so, youll need to calculate the percentage using multiplication and subtraction.

Figuring percentages can be a snap when you know the right formulas.

Shes written tips and tutorials for Microsoft Office applications and other sites.

You can calculate a percentage in Excel using various methods, such as formulas and formatting, but the approach you take depends on both the type of result you need and the version of Excel you are using.

Although theres no basic percentage formula in Excel, you can multiply a number by a percentage using a formula.

For example, if you have a column containing numbers and want to calculate 10 of one of those numbers, enter 10 in another cell, then use a formula using the asterisk as the multiplication operator.

Enter an equal sign ( ) followed by an open parenthesis to begin creating the formula.

Copy the following formula and paste it into cell C1 to calculate 10 of 573.

You can quickly calculate all the numbers in a column by the same percentage using the same formula with a few extra steps.

For instance, if you to calculate 7 tax for the numbers in column A and display it in column C, you would use the following method.

Point to the lower-right corner of the cell until you see a Plus sign ( ).

Select the fill handlePlus sign and drag it down over the other cells in Column B to copy the percentage to those cells, as well.

Select cell C1 and enter (A1B1) in Excel 2019, 2016, Excel 2013, Excel 2010, Excel 2007 or Excel Online.

Select the fill handlePlus sign and drag down over the other cells in Column C.

This will copy the percentage formula to the other cells and automatically calculate the percentages of all the numbers in the first column.

For instance, if youre trying to save 1,500 and are up to 736 in your savings account, you might want to know what percentage of your goal youve reached.

Rather than multiplying, youll need to use a formula to divide.

Enter an equal sign and open parenthesis and select the cell containing the total date; in this example, that would be B1).

Type a forward slash, then select the cell containing the total; in this example, it would be A1.

Your formula should look like this: (B1A1) in Excel 2019, 2016, Excel 2013, Excel 2010, Excel 2007 or Excel Online.

Excel 2016 Version Number Mac Or Excel

Your formula should look like this: B1A1 in Excel 2016 for Mac or Excel for Mac 2011.

Select Percentage.

Adjust the decimals, if desired, then select OK.

If you want to decrease an amount by a specific percentage, Excel can help.

For instance, you might want to decrease your grocery spending on your budget worksheet by 17.

Excel 2016 For Mac Version Number