answersLogoWhite

0


Best Answer

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

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

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)

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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)

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

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

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you subtract 40 percent in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is 100 percent subtract 40 percent?

60


What is 40 percent off of 230?

Start with the original, and subtract 40 percent: 230-(0.4 * 230) = 138


How do you take 40 percent off of 82.20?

Subtract (82.20 x .40) from 82.20, should get 49.32


What is 40 percent off 6.95?

40 percent of 6.95 is 2.78. So if you subtract 2.78 from 6.95, you will get 4.17. So the final price will be 4.17.


What is 40 percent off 54.95?

40 % of 54.95 = (40 / 100) * 54.95 = 0.4 * 54.95 = 21.98 subtract from 54.95 = 32.97 (40 % reduction)


How do you calculate a 40 percent decrease?

X - (X * .4) Find 40% of the value and subtract that result from the original value.


What is 12.90-40 percent off?

A percent off of an amount is found by calculating the percentage, then subtracting from the original amount. So 40% of 12.90 is 5.16. Then subtract from 12.90 to get 7.74


Can Microsoft Excel subtract?

Yes.


What is 40 per cent off 80 dollars?

To calculate 'percent off' you can subtract the percent from 100%, then multiply by the amount, or multiply the percent by the amount, then subtract that from the original amount: 100% - 40% = 60%. (60%) x $80 = $48 (so $48 is the new price). (40%) x $80 = $32 (the amount of the discount is $32). $80 - $32 = $48


How do you calculate 40 percent off?

First you calculate 40% of the original price, which is .4 times original price. Then you subtract that number from the original price to get 40% off. For example, if a pair of shoes originally costs $10 but is 40% off, then you would calculate .4 x 10, which is 4, then subtract 4 from 10, which is 6. So 40 percent off of 10 is 6.


What is 40 percent off 43.20?

If you mean 40% of 43.20, the 0.40 x 43.20 = 17.28. If you mean 40% off of 43.20, then subtract the 17.28 from 43.20 to get 25.92


What is 160 subtract twenty five percent?

The answer is 120, all you have to do is multiply 160 with .25 then subtract 160 from 40 which should be your answer and you will end up with -120, but ignore the negative sign.