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
=a3 / d2
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.
You can not "push" a value from one cell to another cell without writing a specifc macro to do the task. You need to "pull" the value. If you want to copy the value from A1 to B1 if the value of A1 is greater than 6, put the following formula in B1:=IF(A1>6,A1,"")
You cannot move a cell as such by conditions with normal formulas, or affect cells other than one a formula is in directly. You can make a cell equal to another cell using formulas. So you could have a formula that would have B1 be equal to A1 if A1 held a certain value, or else hold a different value. So if you wanted B1 to have 50 in it or the value in A1 if it was higher than 50, then in B1 you could have a formula like this: =IF(A1>50, A1, 50) If you were to remove the value in A1 this would automatically affect the formula in B1 so it might revert to 50. That is why you cannot move it with a formula. Using a Macro or some programming you could achieve it in some complex ways. You could have a it check the value in A1 and set B1 to that value, then do a Paste Special to paste the value in B1 into itself so it does not contain a formula. Finally you could have it remove what is in A1. You would need to study marcros and Visual Basic for Applications to learn more on how to do this.
The forward slash (/) is the division symbol in Excel. =A1/A2 divides the value of cell A1 by the value of cell A2.
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))
A1 --> -10 B1 --> =A1+2 C1 --> =SUM(A1:B1)/2 B1 = -8 C1 = -9
=A1*C1
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.
Let's say you want to take the value of what's in cell A1 and take to the 12th power, then you would type =A1^12 in the formula bar for the cell you want this calculated value to be in.
=($A$1+B1) Putting a dollar sign, as shown on the left, turns the A1 cell into a constant value. Any value in the A1 cell will be unchanged no matter where the formula may be copied and pasted on the spreadsheet.
The answer is in cell C1.Put "this" in cell A1.Put "question" in cell B1.Put the following formula in C1: =A1&" "&B1
=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.