Excel formula help 1

[mmohawk]

I’m trying to create a formula that will subtract (a percentage entered) from (a number entered) per (number of months entered). It should work like this (1200-6%=1128)-6%=1060.32)-6%=996.70…and so on. Any help would be appreciated.

Thanks, Mic

 

[SkipVought]

Mic,

Surely you don't mean that you are ACTUALLY subtracting a percent value from a numeric value like

200 - 10% = 190

You REALLY mean

200 * (100% - 10%) = 180

right?

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi mmohawk,

Not quite sure what you mean by (... entered), but if you have ..
[tt]
Cell Value Meaning
==== ===== =======
A1 6 percentage
A2 1200 number
A3 8 number of months
[/tt]
.. then this formula in another cell ..

=$A$2*(100-$A$1)^$A$3/100^$A$3

.. will give you the result you want (731.4827262 in this example).

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[mmohawk]

I’m trying to get a depreciating value of an object. Each month the value would go down by the percentage that I enter.

Thanks, Mic

 

[SkipVought]

Tony's given you the answer

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mmohawk]

Thank you for your help. It works Great.

Thanks, Mic

 

[SkipVought]

Mic,

Don't forget to

Thank TonyJollans for this valuable post!


This also identifies this posting as helpful to other Tech-Tip members who may have a similar question or would otherwise benefit from Tony's expert tip.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884