0
How do you set up a formula for a balance to subtract a certain percentage from a number entered in a cell?
Wiki User
∙ 11y ago
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
You can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoYou can do it a few ways. Using an example rate of 20% and the cell the original value is in being A2, here are some ways. You could multiply the original value by the remaining percent.
=A2*80%
You could find the 20% and deduct it from the original value, noting the Excel will automatically do the multiplication before the subtraction:
=A2-A2*20%
You could in these cases use the decimal form 0.2 instead and you could also put the percentages into actual cells and have those in the formulas instead, like if the 20% was in B2 then the last formula becomes:
=A2-A2*B2
Add your answer:
Earn +20 pts
What does m- stands for on a calculator?
You can subtract whatever number you have entered into memory.
Lisa has entered a check payment of 213.75 in her checkbook if the old balance was 794 what is her latest balance?
794 - 213.75 = 580.25
What information is entered on the third line of the heading of a balance sheet?
The date The first is the person/ company who you are doing the balance sheet for, and the second is the title "Balance Sheet"
How do you find the true balance of your checking account?
To balance off the account, we look at the side which is larger than the other, make both sides balance by taking the difference between the higher and the lower figure to the side which has lower value and the figure is entered against balance carried down or "c/d". This means the two sides balance then the figure is taken to the opposite side and entered against balance brought down or " b/d' to begin the list of transactions for the following period.
Credit balance brought down on the cash column of a firm a cash book what does it means?
the term balance brought down is an amount entered at the end of a period to balance income and expenditure,which the total of this balance would be the balance brought forward at the start of the next statement of transactions
Does retained earnings go in the trial balance?
Yes Retained Earnings is entered into the Trial Balance, but not if its the company's first month in operation. WebRep currentVote noRating noWeight
Can a small claim be entered if the balance is 168?
Yes, it is possible to get a judgment in Small Claims Court for $168.00.
A net loss is entered in the work sheet's?
Income Statement Credit and Balance Sheet Debit columns.
Why trial word used in trial balance of accountancy?
A Trial balance is basically a test to see if the account will balance before they are finalised. If there are errors its at this point they will be visible. It allows fiance departments to check they have entered all cash in and out correctly.
Does a security guard have a right to fine you on public property?
Generally, no. However, if you entered a public facility and by your entering agreed to be subject to certain rules, you may have made yourself subject to the fine.Generally, no. However, if you entered a public facility and by your entering agreed to be subject to certain rules, you may have made yourself subject to the fine.Generally, no. However, if you entered a public facility and by your entering agreed to be subject to certain rules, you may have made yourself subject to the fine.Generally, no. However, if you entered a public facility and by your entering agreed to be subject to certain rules, you may have made yourself subject to the fine.
What check ensures that the data entered into the database is within a certain range of numbers?
Range
What does a debit do to balance sheet?
The exact definition of debit is The amount entered on the left side of the account. Depending on what account a debit is being entered in, makes the difference as to what happens on the Balance Sheet. An Asset that has a debit balance is increased by a debit, thus increasing assets. A liability (which generally has a credit balance) will be decreased by a debit. Hence, debiting assets such as Cash, Accounts Receivable, Supplies, Equipment, etc will increase Assets on the balance sheet. Debiting liability accounts such as accounts payable, notes payable, etc, will "decrease" said liability therefore decreasing liabilities on the balance sheet.
