Numbers - button function (calculate)

[zace66]

I created a spreadsheet in excel which I have imported to Numbers on my iPad.
It works fine except for one thing.

I had a RECALULATE button as I have random numbers on the sheet abnd want it to update or CALCULATE() to give me new numbers every time I press the button.

But I cant duplicate this on the iPad Numbers - and help appreciated.

Chris (Zace66)

 

[zace66]

No one able to help?

How do i create a function to recalculate a sheet?

 

[sch]

Had a look and couldn't find anything either... not even in the help. Seems rather odd for a spreadsheet program! If you re-enter a value that the calculation depends on, would that do it for you?

BTW, I looked at Docs-to-Go and no joy there either. Very curious.

 

[sch]

Chris,

I just found this (via Google):

Apple - Support - Discussions - click to run a function ...

Not specific to the iPad version, but I'd bet the functionality is similar (and also similar to what I suggested).

Cheers,