Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to deduct percentage after calculate two cells?

Status
Not open for further replies.

DSeyir

Programmer
Mar 3, 2009
3
ES
Hi,
I've the monthly value, that calculated by 12 months will give me 'X', then I want to deduct 20% of it?

can someone help me
 

Wouldn't that be a simple:
[tt]
X - (X * 0.2)[/tt]

??

Have fun.

---- Andy
 
Sorry, I didnt explained myself:
I've one cell with the percentage, one with the monthly value, and need to display automatically on another cell the sum of 12 months deducting what is in the percentage cell in a way that when I change the monthly value it update the rest.

thanks
 
so... 12 * (A1 - (A1 * A2)) ?
(If A1 is the Monthly Value and A2 is the percentage)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top