0
Is there a formula in Excel that will allow a cell to subtract from itself the amount entered into another cell?
Wiki User
∙ 9y ago
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoNo. A cell cannot reference itself in a formula. That creates what is known as a circular referenceIt also cannot have both a value in it and a formula doing something to that value. So you would use a different cell for the formula. Put the original total in one cell, the amount to subtract in another cell and a formula in another cell that will be the original total cell minus the amount to be subtracted cell. So if your original value is in A2 and the amount to be subtracted in B2, then in C2 you could put:
=A2-B2
Add your answer:
Earn +20 pts
How do you calculate time from open time to close time in Excel?
You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3You subtract the opening time from the closing time, which will give you the amount of time it was open. Say your opening time was in B3 and the closing time was in C3, then your formula would be:=C3-B3
How do you take a percent off of a dollar amount?
One way:-- Subtract the discount percent number from 100 .-- Multiply the result by the dollar amount.-- Divide the result by 100 .-- The result is the discounted amount.===============================Another way:-- Multiply the dollar amount by the discount percent number.-- Divide the result by 100 .-- Subtract the result from the original dollar amount.-- The result is the discounted amount.
How do you use an Excel program to subtract from amount to what it equals?
You can subtract with a standard subtraction formula, using the minus sign. You can use actual values, like this: =25 - 6 More commonly you put the values into cells, and use the cell references in the formula to get something like: =A2 - A3 In that case, linking it to the first formula, the 25 could be in cell A2 and the 6 in cell A3.
The formula of neutron?
If you mean to find the amount of neutrons in an atom, you take the atomic mass and subtract the atomic number (the number of protons). That gives you the average number of neutrons.
What's An amount you subtract from the amount of taxes you owe is called?
tax credit
What is a sentence for the word subtract?
Subtract your lunch money from your total.You will need to subtract one number from the other.
What is Another name for formula units?
A formula unit can also be referred to a mole unit. A mole or formula unit is the smallest amount of a substance that contains all the atoms or elements of a substance.
What does subtracting mean?
subtraction means you have to take away from the number
What are kickback codes?
It was a promotion by Virgin. If you entered a code a from another user and topped up with a certain amount then the person that gave you the code got free minutes.
How do you know how to calculate car loan after you have made the first down payment?
It will depend on the terms you have with the dealer. If all of the down payment is going to principal on your car then you would subtract that amount and that would be the amount left on your loan. If only a percent is applied to the amount then subtract that percent from the amount.
How can you do a discount?
subtract the discounted % from the reg. price by first multiplying the discounting % times the reg. price to get the % amount in $ then subtract the difference from the reg. price.
How do you reduce 25 percent of a amount?
You can reduce any amount by 25% by multiplying n-amount by 0.25 and lastly subtract the product from your original starting amount.
