0
Which formula below will add the value of B2 to the value of C3?
Dts2011ttn
The simplest way is as follows:
=B2+C3
Wiki User
∙ 8y ago
ZEALSATY | ISWK
Wiki User
∙ 11y agoIn the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
In the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
Wiki User
∙ 11y agoYou could do it a few ways. The first is the simplest way:
=SUM(Sheet1:Sheet3!B2)
=SUM(Sheet1!B2,Sheet2!B2,Sheet3!B2)
=Sheet1!B2+Sheet2!B2+Sheet3!B2
Wiki User
∙ 11y agoIn the cell where you want to have the answer appear, the simplest way is to enter:
=C2+C3
ZEALSATY | ISWK
WAHGKUGYDYUKGEWKUGKRU
Anonymous
A. =B2+C3. B. =C3+B3. C. = 6+4 D . = B+C
Add your answer:
Earn +20 pts
What Formula in Excel convert lbf to Newton?
If the lbf value was in cell B2, then the formula to convert it to Newton would be:=B2*4.44822162
In excel file hw can you add root 5?
To get the 5th root of a number you use the ^(1/5) method. So if your value was in B2, then the formula would be: =B2^(1/5) To add several values, you use the + symbol as normal.
How do you calculate a 2 percent increase 8 in Excel?
To get 2% of anything, multiply it by 2% or 0.02. You could do that and then add it to the original value to get the increase. Say your value was in cell B2, then you could use any of these: =B2+B2*2% =B2+B2*0.02 Even simpler, an increase of 2% makes a new value of 102%, so you could do either of these: =B2*102% =B2*1.02
How do you calculate in Excel commission of 7 percent on all sales that are at least 25 percent above cost?
Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )Assuming the sale is in B2 and the cost in A2, you could use the following formula to do it:=IF( B2>=A2*1.25, B2*7%, 0 )
How do you use liters per Hectare in Excel in a formula?
There are 10000 litre/hectare in 1 litres per (square meter). So you would divide by 10000. So if the value was in B2, the formula would be: =B2/10000
What is the Excel formula for the selling price if you have cost and margin?
The selling price is the cost plus the margin. If you know the margin as a fixed value and the cost was in cell A2 and the margin in B2, in C2 you could put the following formulas: =A2+B2 If the margin is a percentage of the cost and the margin is in B2, then the formula would be: =A2+A2*B2
How do you subtract 40 percent in Excel?
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*9You 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*9You 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*9You 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*9You 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*9You 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*9You 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*9You 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*9You 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*9You 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*9You 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
Which formula correctly adds the contents of two cells and then multiplies the result by 5 percent Excel?
To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05To multiply a number in B2 by a number in B3 and then get 5% of the total, the formula would be as follows:=B2*B3*5%If you want to increase that total by 5% of itself, then the formula would be:=B2*B3*1.05
What formula would you use in Excel to add cells b1 and b2 together?
You could use either of the following, by putting the formulas in any cells except A1 and B1: =A1+B1 =SUM(A1:B1)
What is the formula of the discriminant?
b2-4ac.
Formula to see if you are over under budget in exce?
You would use the IF function. See the related question below for ways to use it. If your expenses were in cell B2 and budget in C2 you could have a formula in another cell like this: =IF(B2>C2,"Over Budget", "Under Budget")
When do you use with a cell address in Excel?
You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.
