calculate a percentage of a percentage

[ianmb]

hi

I need to calculate a percentage of a percentage but i cannot do it in excel. Basically to be more clear I need to subtract a percentage of an amount and then subtract another percentage of the answer how to do the formula in excel. Have been trying for hours and did not manage!!!!.

Ex subtract 30% of 264 and then subtract 5% of the answer - ie 264-30% = 184.8 - 5% = 175.56

thanks

[sweep]

=(264-(30%*264))-5%*(264-(30%*264))

or more simply

=((264*70%)*95%)

[zbor]

If in A1 is one percent, in B1 is second percent and in C1 is total then:

=C1*(1-A1)*(1-B1)

If you need always same percents then

=C1*(1-0,3)*(1-0,05)

wich is same as =C1*0,7*0,95 =C1*0,665

[ianmb]

thanks a lot!!!!! it worked - quite a simple answer and i was complicating it!! thanks again