>> Need help with a simple formula

[gene.ellis]

I need to write a simple formula but I cannot quite understand how to
do it in Excel.

I need to take the value of a cell (lets call it A8). I need to
subtract 15% from the value of A8. Then I need to take the resulting
value of that and subtract 2.9% from it. finally I need to subtract .3
from the final value. I need to to be displayed in cell B8. I know how
to enter formulas in Excel, but I can't get this one to run right (I
don't know how to reference the result of a earlier calculation in a
later calculation in the formula bar).

Thank you very much!

 

[Anne Troy]

Try this in B8:
=((A8*.85)*.871)-3

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

 

[Guest]

=((A8*0.85)*0.971)-0.3

Vaya con Dios,
Chuck, CABGx3

 

[Niek Otten]

In B8:

=A8*(1-15%)*(1-2.9%)-0.3

 

[Bob Phillips]

=((A8*(1-15%))*(1-2.9%))-0.3

and add this formula to B8

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[gene.ellis]

Thanks everyone!

 

[Bob Phillips]

Glad to see a like mind on the (1-percentage) approach <bg>

Bob

 

[Niek Otten]

:-}

Niek

Glad to see a like mind on the (1-percentage) approach <bg>

Bob