Excel formula

[Doug]

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??

 

[dlw]

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

 

[KimW]

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

 

[Gord Dibben]

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