0
What is a formula which would add A1 A2 and A3 and divide by 3?
Wiki User
∙ 13y ago
To add the 3 cells and divide the total by 3, you could do it several ways:
=(A1+A2+A3)/3
=SUM(A1:A3)/3
=SUM(A1,A2,A3)/3
Wiki User
∙ 13y ago
Erica Oyao Peramide
Add your answer:
Earn +20 pts
What formula would you use to add together the cells A1 and B1?
=A1+B1
How do you add a spreadsheet column?
If you have values in cells A1 through A12, you can add the column of values with the formula =SUM(A1:A12) .
What is the formula that divides the value of the cell A1?
You can divide by anything except zero. So you can use a number or a cell with a number in it. You use the / symbol for division. So your formula to divide something in cell A1, which must go into a cell other than A1, could be like either of the following: =A1/10 =A1/B2
How would you add two entire worksheets in excel?
If you have numbers on two worksheets in cells A1:C23, you can use the formula:=SUM(sheet1!A1:sheet1!C23)+SUM(sheet2!A1:sheet2!C23)
What do you divide by if you want 20 percent in Excel?
To get 20% of anything you divide by 5. In Excel you could do it several ways. If the value you want to divide was in cell A1, then in another cell you could put the following formula: =A1/5 Alternatively you could put the 5 into another cell, like A2, and then refer to it in the formula as follows: =A1/A2
Why are cell addresses used in formulas in spreadsheet?
Because it means that if you change the value in a particular cell, the formula will automatically update its result. Say you want to add 45 and 19. If you put 45 into cell A1 and 19 into cell A2 then in cell A3 you could have a formula: =45+19 That formula will give the result 64, which is correct. But if you then wanted to change one of the two original values, you would have to change the formula again to get the correct result. If you put 30 into A1 without changing the formula in A3, A3 will still show 64. It is still being told to add 45 and 19. The formula has no connection to the cells A1 and A2. You would have to change the formula in A3 to be =30+19 to get the correct result if you want to add 30 and 19. That means you keep having to change the formula to add different numbers, which is not very efficient. So what we do is put cell addresses instead of values into formulas. So into A3 you would put: =A1+A2 For the original two values it will give 64. Then, without having to change the formula, if you change the 45 in A1 to 30, the formula will automatically add the 30 and 19 giving you 49, because the formula is telling it to add whatever values are in those two cells. So no matter what two values you put into A1 and A2, the formula in A3 will always add them.
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 formula adds 100 to cell A1?
=A1+100 or =100+A1 This can be put in any cell except A1, so the total will show in the new cell, not in A1 itself. To actually add 100 to the A1 itself, first type 100 into another cell. Then select it and copy it. The select A1. Go to Paste Special and click on Add in operations, and then click OK. 100 will be added to the value that was in A1.
What formula do you use to get a percentage of 2 numbers?
If you have two numbers and want to find what percentage they are of each other, you can do some division. So for example, if you want to find out what percentage of 96 is 75, then you would divide 75 by 96 and format the result as a percentage. So if 75 is in cell A1 and 96 is in cell A2, then in another cell you would put the following formula: =A1/A2 It will be 78%. If you want to find what percentage of 75 is 96, then the formula would be: =A2/A1 It will be 128%. The numerical difference between 75 and 96 is 19. If you want to find what percentage of 75 or 96 19 is, then you divide the 19 by the 75 or by the 96. You could have a formula in a cell A3 which finds the difference between the two numbers first as follows: =A2-A1 That will be 19. Then to find what percentage of 75 19 is in another blank cell you would have the formula: =A3/A1 To find what percentage of 96 19 is in another blank cell you would have the formula: =A3/A2
If you use the addition formula to add 100 cells in spreadsheet what could we solve it?
=SUM(A1:A100)
How do you write a formula in cell b1 in excel that shows if cell a1 is greater than 4 enter the number 150 or if cell a1 is less than 4 enter 75?
=IF(A1>4,150,75) In this case if A1 is 4, then 75 will show. If you want 150 to show when A1 is 4 then the formula would be: =IF(A1>=4,150,75)
Formula to calculate in Excel?
In Excel, you can use formulas to perform calculations. For example, to add cells A1 and B1, you can write the formula "=A1+B1" in a different cell. Similarly, you can use formulas for subtraction, multiplication, and division by replacing the "+" operator with "-" for subtraction, "*" for multiplication, and "/" for division, respectively.
