Currently Being ModeratedMar 20, 2012 6:01 AM (in response to teemmiiuurr)
One easy solution is to place a checkbox (whereever is convenient) , then click the check box (there is not button GUI element in Numbers). Changing anything in a table will cause the recalculation to start.
Currently Being ModeratedMar 22, 2012 4:32 PM (in response to teemmiiuurr)
I am sorry. I do not have Numbers for iOS. I made the mistake of thinking this trick would work with the iOS version. You should try posting this question in the Numbers for iOS forum located here:
If aléa means hazard or warning or error then there is a problem with the formula in the cell. Can you click the symbol in the cell indicating the error and post the message?
Currently Being ModeratedMar 23, 2012 12:12 AM (in response to Wayne Contello)
no problem )
i just need to use a number between 0 and 1 and need it to be calculated automatically when i hit my screen
i need each time a new number each time i hit my screen
there is no error, and the formula is =alea
thanks for your kindness
Currently Being ModeratedMar 24, 2012 5:06 AM (in response to jaxjason)
alea is a function who pick a random number between 0 and 1, i don t know the function in english sorry
and on excel file when you you hit suppr in a cell the fonction alea refresh ech time, so you can have easely a random number
Currently Being ModeratedMar 24, 2012 7:39 AM (in response to teemmiiuurr)
alea() is not a function in Numbers.
you can tell because when you type it in as:
the lower case letters "alea" do not become "ALEA" when you type the open parenthesis. The legitimate list of functions in Numbers is available in the help file and in a function summary. You can open the summary by starting to enter a formula by enter the "=" in a cell, then clicking (or touching) the "fx" button in the toolbar (top left corner or the screenshot).
I don't think I can be much more help since I don't have an iOS device with Numbers.
I hope this helps. There are ARE random functions:
Maybe this button gives you a list of functions:
Currently Being ModeratedMar 24, 2012 9:25 AM (in response to Wayne Contello)
Currently Being ModeratedMar 25, 2012 5:47 AM (in response to Jeff Shenk)
I seldom use Numbers for iOS, so I am not exactly adept at working with it, but it appears that RAND() in an arbitrary cell does not update when a checkbox in another cell is checked (or unchecked). However, if the checkbox is put in cell A1, and the following is substituted for RAND(),:
=IF(A1, RAND(), RAND())
it will update each time A1 changes state.
If you can check and uncheck a box in iOS with fewer than four taps, I haven't figured it out.
Apparently, iOS displays RAND() as RAND, so, for a check box in A1 as the button, I think the French would be:
=SI(A1, ALEA, ALEA)