answersLogoWhite

0

If we say the numbers you want to get 10 percent of are always in cell A2, then you could use any of the following formulas:

=A2*0.1

=A2*10%

=A2/100*10

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How do you find the percentage on Excel?

You find percentages with excel the same why you would with any other method. Multiply the number times the decimal equivalent of the percent. If you want to find 12% of $132.56, use this formula: =132.56*.12If you store the number in cell A1 and the percent in A2, you can use the following formula to calculate the results: =A1*A2


In Microsoft Excel how do you use a formula to calculate the percentage of use of a set of symbols?

In A1, put the total number of symbols.In B1, put the number of symbols used.In C1, enter the formula =A1/B1Format C1 for percent and observe the answer.


What would be the EXCEL formula to calculate 15 percent of 6058.82?

15 / 6058.82 = 0.00247572959751238690041955364246. Formatting the cell for percentages will yield a result of 0.25%


What is Microsoft Excel formula to calculate a hourly rate with a 5 percent increase?

Put the rate in a cell, let us use B23. Calculate the new rate in cell C23 using this formula:=B23*1.05


What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


What is the loan constant formula in Excel and how can it be used to calculate loan payments?

The loan constant formula in Excel is PMT(rate, nper, pv). This formula can be used to calculate loan payments by inputting the interest rate (rate), the number of payment periods (nper), and the loan amount (pv). Excel will then calculate the fixed payment amount needed to pay off the loan over the specified period.


What is the formula to determine what the whole muber of 49206 with an increase of 40 percent?

I need the excel formula to determine what the number is if we grew 40% over prior year if current number is $49,206


Mathematical equation assigned to a cell that Excel uses to calculate a result?

formula


How do you find 30 percent of number in excel?

Multiply the number by 0.3


What is the excel formula symbol for any number?

1()


What is the formula if price drops in 30 percent in excel?

If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is: =A1*(1-(30/100))


Is there an Excel formula to calculate Federal tax for an unmarried individual in Ontario?

Excel can do any calculations. It won't have that particular requirement already built in, but once you know how to do calculations with Excel and once you know what is required to do the calculation you need, you can then build formulas to do it. Something like that would not be done in a single formula. You would have a number of formulas to calculate the different elements. It can definitely be done. A basic knowledge of Excel and knowledge of the process required to calculate your requirement, which you can probably get through the authorities, probably on their website or through documentation they provide, is what you will need.