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