Excel formula question

roadwarrior · 08-28-2006, 05:10 AM

I am making some charts. I have all my formulas correct for my cells. The only cell that I am having problems with is: Example: I need to figure the formula for cost + 20%. ???? =sum(d3+20%) I know the formula I just showed is incorrect but its an idea of what I need. Can anyone help.

Inactive · 08-28-2006, 05:20 AM

adding 20% to the inital figure
cost + cost*20%

cost(1 + 1*0.2)

cost * 1.2

so would that not be what you type in place of
=sum(d3+20%)
use
=sum(d3*1.2)

roadwarrior · 08-28-2006, 06:31 AM

Thank You for the help. That formula maks life easier on the charts that I'm doing

08-28-2006, 05:10 AM	#1 (permalink)
roadwarrior Registered User Join Date: May 2005 Location: Tennessee Posts: 51 OS: xp	Excel formula question I am making some charts. I have all my formulas correct for my cells. The only cell that I am having problems with is: Example: I need to figure the formula for cost + 20%. ???? =sum(d3+20%) I know the formula I just showed is incorrect but its an idea of what I need. Can anyone help. Last edited by roadwarrior; 08-28-2006 at 05:16 AM.

08-28-2006, 05:20 AM	#2 (permalink)
Inactive Registered User Join Date: Apr 2005 Posts: 1,704 OS: ~	adding 20% to the inital figure cost + cost20% cost(1 + 10.2) cost * 1.2 so would that not be what you type in place of =sum(d3+20%) use =sum(d3*1.2) __________________ "it takes two to lie, one to lie and one to listen" Homer

08-28-2006, 06:31 AM	#3 (permalink)
roadwarrior Registered User Join Date: May 2005 Location: Tennessee Posts: 51 OS: xp	Thank You for the help. That formula maks life easier on the charts that I'm doing