0
What is the formula to calculate 149.99 minus 30 percent in Excel?
Wiki User
∙ 8y ago
There are lots of ways of taking 30% of 149.99 away from 149.99. It is also the equivalent of getting 70% of it. Assuming the 149.99 is in cell A2, then any of these formulas will do it:
=A2 - A2 * 30%
=A2 - A2 * 0.3
=A2 * 70%
=A2 * 0.7
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
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.
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
Mathematical equation assigned to a cell that Excel uses to calculate a result?
formula
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))
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 do you do to calculate a formula in excel you have hourly rate of 6.80 but need to add 20 percent for a weekend rate any ideas what to do?
=6.80*1.20 or =D16(or whatever cell the hourly rate is in)*1.20
What is the formula used to calculate result in Microsoft Excel?
The formula you use depends upon what you are trying to calculate. If you want to multiply two cells (e.g. A1 and C2), the formula would be =A1*C2.
How do you calculate tax 19 percent of R cost in excel?
Multiply the retail cost by 0.19
How do you put a formula in Excel to calculate the 10 percent of any number?
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
What is the Excel formula to calculate the total of values in cells d7 through e20?
=SUM(D7:E20)
