So I have an Excel program that creates random numbers when F9 is hit. How would that work in Numbers? The keypad that comes up does not have F9 on it.
I'm using the new IPad
Thanks
iPad 2, iOS 6.0.2
one techinique to get Numbers to update random values is to place a check box in a field. Then touch the checkbox (doesn't matter the state of the check box) to get the random numbers to update.
In Numbers, click on the Function button on the tool bar and chose Show Function Browser. Scroll down to RAND(). It says:
Any time you change a value in the table, a new random number greater than or equal to 0 and less than 1 is generated.
Also see RANDBETWEEN()
Ian.
If you are talking about Numbers on the Mac, a checkbox (as Wayne talked about) will refresh all random numbers.
If you are talking about Numbers for iOS, in addition to a checkbox you need to use a formula like this:
=IF(A1,RAND,RAND) where A1 is the cell with the checkbox
Alternatively, in iOS Numbers, you can click on the cell that has the RAND formula, copy, click again, paste - paste formulas. Kind of a long way to do it but it will referesh all calculations, including all random numbers without you having to rewrite the spreadsheet with =IF(...) formulas.
Numbers and random numbers
