How do you subtract 40 percent in Excel?

Answer 1

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

Answer 2

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

Answer 3

That could mean two things. Either to subtract 40% of a number from itself or to subtract the actual value 40% from a number. It is more likely that you mean the first. Reducing something by 40% is the same as finding 60% of it. For each of those there are various ways you can do it. We can also use 0.4 for 40% or 0.6 for 60% which is the decimal form.

To subtract 40% of a number from itself, assuming the value is in cell A2, you could do any of the following:

=A2 - A2 * 40%

=A2 - A2 * 0.4

=A2 * 60%

=A2 * 0.6

If you wanted to actually take the value 40% from a value, you could do it like this:

=A2 - 40%

=A2 - 0.4

Answer 4

There are lots of ways you could do it. Say you put 100 into cell A2 and your formula in B2, then the formula in B2 could be any of these:

=A2*0.9

=A2*90%

=A2-(A2*10%)

=A2-(A2*0.1)

You could also use the 100 direct in the formulas, though that is not advised, in which case the formulas would be:

=100*0.9

=100*90%

=100-(100*10%)

=100-(100*0.1)

Answer 5

You can do it lots of ways. You can think of it as taking 10% away or just getting 90% of the original value. Assuming your value was in cell B2, any of these would work:

=B2-B2*10%

=B2*90%

=B2-B2*0.1

=B2*0.9

=B2/10*9

Answer 6

If cell B3 has the total, and you want to show the percentage off in B4, type any of these into B4:

=B3*(100-50)/100

=B3/2

=B3*50%

=B3*0.5

Answer 7

= [Cell]*(1-x%) e.g. = A1*(1-15%)