0
What is the correct formula to calculate the total cell of B3 and B4?
Wiki User
∙ 9y ago
The proper and best way to do it is:
=B3+B4
You could also do it in any of the following ways:
=SUM(B3:B4)
=SUM(B3,B4)
=SUM(B3+B4)
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
On iwork spreadsheet how do you make a column calculate VAT eg column 1 type in 100 then column 2 would automatically calculate vat and column 3 would automatically calculate total inc vat?
If the 100 is in cell A3 and the VAT rate is 15%, then in cell B3 you would have the following formula: =A3*15% However it is better to put the VAT rate into a cell by itself, like perhaps in cell B2. Then the formula would be as follows, with the dollar symbols enabling the formula to be copied while keep using the 15%. =A3*$B$2 Then in C3 you would have the following formula to get the total: =A3+B3
Which adds all of the numbers in a range of cellsprovides a convinient means to calculate a total?
=SUM(A1:A15) If this SUM formula is put into cell A16, then the numbers in the cells above (A1 to A15) will be shown in cell A16 as a total.
Insert a formula to calculate the total number of correct answers. What would be the formula?
That is a very unclear question, so it depends what you mean. If you mean you have someone typing in answers to a test and want to count the amount of correct answers they have, there are different ways you could do it. In the cell beside each answer given, you could put a 1 for a correct answer and a 0 for a wrong one and then total them up using the SUM function. If you have the correct answer in a cell and their answer in another one, you could use an IF function to compare the answers, and give 1 for a correct one and 0 for wrong ones, and again use SUM to total them. So say the correct answers were in the cells from A2 to A10 and you entered their answers in B2 to B10. Then in C2 you could put the following formula:=IF(A2=B2,1,0)You would copy that formula down to C10, and you'd have 1 for each correct answer and 0 for the wrong ones. Then in C11 you could put the following formula to add them up:=SUM(C2:C10)You would naturally adjust the cell references to suit the cells you are using in all of these formulas.
How do you calculate salary in Excel sheet?
Put the hourly rate in cell A1 and the number of hours in cell A2. Put the following formula in cell A3 [=A1*A2]. You will see the total of Rate X Hours in cell A3.
How can you check and correct your Lewis structure?
Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.
Which answer is correct for using a cell address in a formula in known as formularizing or prefixing or cell referencing or cell mathematics?
cell referencing
Mathematical equation assigned to a cell that Excel uses to calculate a result?
formula
When using a formula to calculate a percentage increase you must refer to the cell where the percent is located?
Yes, you can do that. You could also put the percetage directly into the formula. The best way is to put the percentage into a cell and refer to that cell in your formula.
What is Microsoft Excel formula to calculate a hourly rate with a 5 percent increase?
Put the rate in a cell, let us use B23. Calculate the new rate in cell C23 using this formula:=B23*1.05
What is the correct formula that will divide cell k13 by 12?
=K13/12
Is there a formula in Excel that will allow a cell to subtract from itself the amount entered into another cell?
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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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
In Microsoft Excel you want to use this if statement ife8yescorrectfalse how do you make the if statement cell blank if there is no text in cell e8?
If the word Yes is in E8, the following formula will put Correct in the cell that the formula is in, or else leave it blank, which is done by have a two sets of double quotes with no gap between them after the final comma. =IF(E8="Yes","Correct","") You can exchange the Yes with whatever you are testing for and the Correct with whatever you want to put in the cell. Another thing you can do is use the IsBlank function to test if the cell is empty. If it is empty it will leave the cell with the formula blank or will put the word Correct in, no matter what is in the cell E8 if it is not blank. That may not be exactly what you want to do, but this would be the formula. =IF(IsBlank(E8),"","Correct") If you want to allow numbers to be in the cell, but no text you could use the IsText function: =IF(Not(IsText(E8)),"","Correct") Probably the first formula or a slight variation of it is what you are looking for.
