2011/8/20 Andreas Säger <[email protected]>: > Very easy: F2, Space, Enter applies a dummy change to the formula which is > forced to recalculate then. > > Like any other cell function, RANDBETWEEN(min ; max) recalculates when any > of the input values change. > =RANDBETWEEN(A1;B1) recalculates when either one of A1 or B1 has been > modified. > In most cases the function is used with constants as in =RANDBETWEEN( 1 ; > 100 ), so the recalculation will never be triggered. > =INT(RAND()*(max-min)+min) +1 makes use of the volatile RAND function. It > recalculates on every change in the whole document.
But what about if he has a few cells with those formulas and only want to recalculate ONE of them? That's one of the things that I though he could have meant… You are probably right, though, Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > -- > View this message in context: > http://nabble.documentfoundation.org/Recalculate-Rand-between-targeting-a-particular-Cell-or-Cell-Range-tp3270325p3271061.html > Sent from the Users mailing list archive at Nabble.com. > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
