how to refresh alea formula

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.

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:

https://discussions.apple.com/community/app_store/iwork_for_ios

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?

can you post your formula and a screenshot?

to take a screenshot on the iPad press the power button and the home button at the same time

Can someone with the knowledge please translate alea for us into the english worded function? I want to help some but cannot duplicate the function on my ipad without more.

Jason

alea() is not a function in Numbers.

you can tell because when you type it in as:

"=alea("

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:

rand(), randbetween()...

ENG: RAND

DEUTSCH: ZUFALLSZAHL

ENG: RANDBETWEEN

DEUTSCH: ZUFALLSBEREICH

Maybe this button gives you a list of functions:

Wayne,

I think ALEA() is the French equivalent for RAND(), but since I don't read French I can't be sure.

As such, on a Mac, cycling a checkbox should refresh it, but I think I may have heard that on an iPad that doesn't necessarily apply.

OK. Now I feel stoopid (sic). That word didn't look German but something made me think it is-- which also explains why there was no good translation available.

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)