0
How do you create a complex formula that calculates a 30 percent decrease in Excel 2010?
Wiki User
∙ 9y ago
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
You could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoYou could do it in several ways. You could use the 30 percent directly or use 70 percent, as that is what is left when you reduce by 30 percent. Assuming the value was in D3, you could use any of these formulas to do reduce the value by 30%:
=D3-D3*30%
=D3*70%
=D3/10*7
=D3/100*70
To find what the decrease actually is, which you could be looking for, you could use these formulas:
=D3-D3*70%
=D3*30%
=D3/100*30
=D3/10*3
In both instances there are other ways it could be done.
Add your answer:
Earn +20 pts
How do you create a complex formula that calculates a 30 percent decrease?
We're stumped. The only formula up with which we're able to come is a simple one.If the original quantity is 'Q', then after a 30-percent decrease, the new quantity 'N' is:N = 0.7 Q
Formula for percent of increase and decrease?
% increase or decrease = |original value - new value| /original value * 100%
Create a formula in the row containing the 15 percent increase label that calculates a 15 percent increase in total montly sales?
If total sales is in M2, then put this formula in N2 to show 15% increase in sales.=M2*1.15
3.50 to 2.80 what is the percent decrease?
Percent change can be found using the formula below:(new amount) - (original amount)% change = __________________________(original amount)Using this formula, we find that2.8 - 3.5 -0.7_______ = ____ = -0.2, which equals a 20% decrease (negative answer)3.5 3.5
What is the percent decrease from 96 percent to 84 percent?
12.5% decrease.
What is the percent decrease from 42 percent to 38 percent?
9.5238% decrease.
What is the definition of percent of decrease?
the amount of decrease in a percent
What is the percent decrease from 80 to 64 percent?
20% decrease.
what is the percent decrease of 300 to 240?
20 percent decrease.
What is percent of decrease?
Formula:% decrease = |original value - new value|/original value * 100%Example:To get % decrease from 731 to 581:= |731 - 581|/731 * 100%= 150/731 * 100%= 0.2052 * 100%= 20.52%
What is the percent decrease of 148 to 121?
148 to 121 is a percent decrease of 18.24%
What is the percent decrease from 14.00 to 9.00?
The percent decrease from 14 to 9 is 35.71.
