0
=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.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is the formula if price drops in 30 percent in excel?
If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is: =A1*(1-(30/100))
The formula used to multiply cell A1 by cell C1 is?
=A1*C1
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.
What is the formula for this question?
The answer is in cell C1.Put "this" in cell A1.Put "question" in cell B1.Put the following formula in C1: =A1&" "&B1
How do you write an excel formula to find the gross margin percent if A1 is cost and B1 is retail?
"=((B1-A1)/B1)*100" alternatively if you format the cell as a %, it would just be "=(b1-a1)/b1"
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)
What would the Excel formula be for If the text in Cell A1 matches the Text in Column A on Sheet 2 then place an X in Cell B1 on Sheet 1?
If you want to compare the contents of cell A1 on Sheet1 to A1 on Sheet2 and put an X in cell B1 on Sheet1, then in cell B1 on Sheet1 you would put the following formula: =IF(A1=Sheet2!A1,"X","")
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
What is in a formula in a spreadsheet?
A simple formula put into D1 could be: =A1*B1 Which is asking the numerical data in cell A1, be timed by the numerical data in cell B1, and show the answer in cell D1.
What is the formula of take away in excell?
Assuming "take away" means to subtract, here is the formula for subtracting the contents of cell B1 from the contents of cell A1:=A1-B1
In excel if value is in one column automaticlly put formula in another column?
There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.
How can you enter into a cell in excel and have it record to another worksheet?
If you have a value in cell A1 on Sheet1 and you want it to appear in Sheet 2, you use a formula. So in a cell on Sheet2 type: =Sheet1!A1 Sheet1 is the sheet name. The exclamation mark separates it from the cell reference. Now whatever is in the cell A1 on Sheet1 will appear in the cell with that formula.
