Hi Sean
Try putting your Total in Say F1
Then
A1 =fixed amount
B1= fixed amount
c1=F1*% so if C1 was 25%, it will be =F1*.25
D1=F1*%so if C1 was 10%it will be =F1*.10
E1=F1*%....etc,etc.

HTH
Michael


"sean fergusson" wrote:

Ok, I wasn't very good at maths so bear with me.

I need to calculate figures based on a percentage of the whole.

ie a+b+c+d+e=T

now the doozy, a is fixed b is fixed and everything else is a percentage of
T.

the calculation is to work out gross profit percentages so all the
percentages are tax, commisions and for the sake of the problem a 30% GPP
giving us a total Retail Price (T.) can excel equate these figure and if so
how? if any one can help please do as i am tooo young to have a heart attack
from stress. Thanks in advance for anyone who can help.....

--
Sean Fergusson

National Security Systems

--
Sean Fergusson

National Security Systems

Ph: 1300 556 469
Fax: 9300 1011

Mob: 0439 359 264