0
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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What happens in Excel when a user presses Ctrl Home?
It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.It will bring you to cell A1 in the worksheet.
What key combination will move the cell to A1?
Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.Ctrl-Home will select A1. You can also use the F5 key to open the Goto, and then go to cell A1.
The formula used to multiply cell A1 by cell C1 is?
=A1*C1
How do you automatically duplicate information from an Excel cell to another?
If you have a value in, for instance, cell A1 then if, for instance, you put =A1 in cell B1 then cell B1 will now contain a duplicate of cell A1.
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.
How do you move straight away from cell A1 to cell B320?
Press the F5 key, which opens the "Goto" dialog box. Then Enter "b320" where it says "reference". Click OK. You are now in the B320 cell. Press F5 key again to go back to A1.
What is the meaning of this cell A1A2?
There is no cell A1A2. What you may mean is A1:A2 which refers to the range consisting of cell A1 and cell A2.
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","")
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)
How do you make A1 an active cell?
The easiest way is to press Ctrl - Home. You could also click on A1 using the mouse, or using the arrow keys, move the cursor to A1. You could also press the F5 key and use the Goto command to go to A1. You could also type A1 in the Name Box.
What is the cell reference A1 for Microsoft Excel?
A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.
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
