| Author |
Message |
MyrddinE
Joined: 25 Feb 2008
Posts: 2
|
 Posted: February 25, 2008 10:21 PM Post subject: CellSheet Formulas |
 |
|
I can enter formulas on Cellsheet, and they work just fine... such as sum(a1:a99). But the problem is they work instantly, and the RESULT of the formula is put into the cell.
I want Cellsheet to act more like a spreadsheet... I want to enter a formula, and have it recalculate the current value when I choose Recalc from the menu. I'm obviously doing something wrong... can someone tell me what? |
|
| Back to top |
|
 |
kkyolpep
Joined: 18 Apr 2008
Posts: 4
|
| Posted: April 18, 2008 10:59 PM Post subject: |
|
|
| When you put in sum(a1:a10) (for example) you need to place a = in front of it like this =sum(a1:a10) Now every time you update one of the numbers from A1 to A10, the cell you put this equation into (lets say A12) will automatically update, so A12 will always add up A1 to A10. I see you wrote this a while back so I hope you get this. |
|
| Back to top |
|
|
|
