Tags Math and Arithmetic Algebra Microsoft Excel

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

What is the formula to calculate 149.99 minus 30 percent in Excel?

Updated: 12/13/2022

Wiki User

∙ 9y ago

Best Answer

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

∙ 9y ago

This answer is:

Add your answer:

Earn +20 pts

Q: What is the formula to calculate 149.99 minus 30 percent in Excel?

Write your answer...

Submit

Still have questions?

imp

Related questions

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))

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

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 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)

Trending Questions

You have media player that uses 5.6v and 2000ma you want to use in your car with a car adapter that has 2000ma with voltage settings of 3v-12v can you safely use the 6v setting or not? What is the mouse called that is motion sensing? 8 ounces of water is equal to how many teaspoons of water? What song has the words come on someone try and run old reds itching to have some fun? What is the minimum age to be a computer programmer? Which everyday items is a microchip in? Where can one purchase a wireless USB adapter? Will a Nvidia GTX 650 1 gb run Skyrim on Ultra? Can you get a memory card for a nokia 2630 phone? What is the valid reason for a switch to deny port access to new devices when port security is enabled? What are the types of perspective system? What is the key board shortcut for repeating command? Do people make GBA games into flash games? How can you stop PC from going into sleep mode? What is pc245? Why is Sergei the meerkat so awesome? How do you list all of the files in the current directory in Unix? How does CPU send instructions to the different parts of the computer? What is the difference between oracle 10g and 11g? What are network devices?

Previously Viewed

What is the formula to calculate 149.99 minus 30 percent in Excel?

Unanswered Questions

How do you round 2.975 to one decimal place? What is 652 divided by 8? What is the number 100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000? 9 divided by 351 answers is? What is 10 to the power of 80? How many 80s in 4000? How many hours is 30000 minutes? How many years are in 108 months?

Resources

Top Categories

Product

Company

Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.