What formula do I need to ensure cell A1 changes?
2006-06-26 00:48:00 · 7 answers · asked by Ian G 1 in Computers & Internet ➔ Programming & Design
A cell can either contain data or a formula, not both.
You will need to create a macro and assign it to the onChange event for that cell.
2006-06-26 02:25:50 · answer #1 · answered by anonymous_dave 4 · 4⤊ 0⤋
You need to use an IF statement. Click the little "fx" to the left of the formula bar. On the window that pops up, select the category "Logical", then click on "IF". Below it will give you a description of what it does and how you input the information in the formula. Click OK and another window will pop up where you can input the information or conditions you want.
Here's another thing you want to do. On the menu bar, go to Tools, then Options, then select the Calculation tab on the window that pops up. Under the Calculation page you want to make sure that Calculation is set to Automatic and not Manual. If it is set to manual, it will only update the calculations whenever you press F9 or right before you save the document. So you may have updated say cell C3, which should have changed the value in cell A1, but if it is set to manual, A1 won't update till you press F9 or save it. When Calculation is set to Automatic, it will update immediately. Sometimes Excel will switch back over to manual for some reason or another, so make sure to check the Calculation settings if it's not updating properly.
2006-06-28 03:15:53 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
If the value needs to be the sum of other cells insert into A1 =sum(a2:a3) for example. Check out the help pages on excel and they have pretty throrough info on all formulaes
2006-06-26 01:01:31 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Use both of both less than: =variety("A1") or = Cells(a million,a million) note that once using 'variety' you need to apply inverted commas, and for this reason won't be able to be used with a formulation that returns the Rows or column numbers. while at the same time as using 'Cells' you do not use any inverted commas and for this reason is extra versatile. Cells(RowNum,ColNum)
2016-11-15 06:41:35 · answer #4 · answered by cozzens 4 · 0⤊ 0⤋
u can use formula in other cell =a1
2006-06-26 00:53:08 · answer #5 · answered by KUMAR 3 · 0⤊ 0⤋
You need to use the formula bar. And put the equals sign in before you put in your info. What exactly do you need to do?
2006-06-26 00:51:39 · answer #6 · answered by K 3 · 0⤊ 0⤋
u need to do an IF formula....good luck
2006-06-26 00:50:54 · answer #7 · answered by Pat 4 · 0⤊ 0⤋