Excel formula

D

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

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)
 
G

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
 
Top