Excel formula
 

I'm trying to calculate a net total by taking a number times 40% and then
deduct that percentage from the number to get the net total.

How do I create this formula in Excel??

Excel formula
 

just multiply the number by .6 ie. =A1*.6
if the number is in cell A1

"Doug" wrote:

I'm trying to calculate a net total by taking a number times 40% and then
deduct that percentage from the number to get the net total.

How do I create this formula in Excel??

Excel formula
 

You can also use the following (where x represents your initial number or the
cell where your initial number is entered)
=x-(x*.4)

"Doug" wrote:

I'm trying to calculate a net total by taking a number times 40% and then
deduct that percentage from the number to get the net total.

How do I create this formula in Excel??

Excel formula
 

Short way around with number in A1 and formula in B1

=A1 * .6

Long way around as you asked.

=A1-(A1 * .4)


Gord Dibben MS Excel MVP

On Thu, 29 Oct 2009 12:34:01 -0700, Doug
wrote:

I'm trying to calculate a net total by taking a number times 40% and then
deduct that percentage from the number to get the net total.

How do I create this formula in Excel??

Excel formula
 

=A2*(1-40%)
--
David Biddulph

Doug wrote:
I'm trying to calculate a net total by taking a number times 40% and
then deduct that percentage from the number to get the net total.

How do I create this formula in Excel??