answersLogoWhite

0

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

User Avatar

Wiki User

9y ago

What else can I help you with?

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


How do you calculate tax 19 percent of R cost in excel?

Multiply the retail cost by 0.19


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

Trending Questions
Interface VLAN 1 has ip address of 192.168.1.2 255.255.255.0 and the default gateway of 192.168.1.1. why does interface VLAN 1 require an ip address in this this LAN? What is the length a fancy rat? What is Language Computer Corporation's population? How I delete files or folders that require permission in Windows 7 or Vista? What contribution did Bill Gates Paul Allen Steve Wozniak and Steve Jobs make to computer usage? What is the difference between sqlplus and sqlserver? How many bottles in salmanazar? When you log on to your computer all you see is a black screen you opened up avast with task manager and scanned the computer it had 2 severe viruses which you deleted still no desktop what do you do? Drow a er diagram of a supermarket? What multiple workbooks in the workbook window lets you view their contents at the same time? How do you access your local disk in Windows XP? When DNS is installed on a new domain controller are AD-integrated zones replicated to the new DNS server automatically? 2GHZ dual core processor or 3GHZ celeron processor? What is electrically capable of archiving data and information on a computer? Which windows utility can be used to find out what processes are launched at startup? How many cusecs to 1 cubic feet? Is there any difference between a laptop CD-DVD drive and a PC CD-DVD drive in the way that they read the data from a CD? How many ml in a tsp? What gives a wealth of informatin about installed hardware and software the current system configuration and currently running programs? Where can one get free advice on fixing PC errors?