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!

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

wrote in message
ups.com...
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!

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

Vaya con Dios,
Chuck, CABGx3



" wrote:

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!

In B8:

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

--
Kind regards,

Niek Otten

wrote in message
ups.com...
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!

=((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)

wrote in message
ups.com...
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!

Thanks everyone! :)

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

Bob

"Niek Otten" wrote in message
...
In B8:

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

--
Kind regards,

Niek Otten

wrote in message
ups.com...
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!

:-}

Niek

"Bob Phillips" wrote in message
...
Glad to see a like mind on the (1-percentage) approach <bg

Bob

"Niek Otten" wrote in message
...
In B8:

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

--
Kind regards,

Niek Otten

wrote in message
ups.com...
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!