LibreOffice Help - master/text/scalc/01 — Catalan @ TDF Weblate - LibreOffice: <bookmark_value>RAND function</bookmark_value><bookmark_value>random numbers;between 0 and 1</bookmark

Translation

Context 04060106.xhp bm_id3164800 help.text

English

odp65

Catalan

Needs editing

Skip

Context	English	Catalan
04060106.xhp bm_id3164669 help.text	<bookmark_value>random numbers; between limits</bookmark_value><bookmark_value>RANDBETWEEN function</bookmark_value>	<bookmark_value>nombres aleatoris; entre límits</bookmark_value><bookmark_value>funció ALEATENTRE</bookmark_value>
04060106.xhp hd_id3164669 help.text	<variable id="randbetween"><link href="text/scalc/01/04060106.xhp#randbetween">RANDBETWEEN</link></variable>	<variable id="randbetween"><link href="text/scalc/01/04060106.xhp#randbetween">ALEATENTRE</link></variable>
04060106.xhp par_id3164711 help.text	<ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp>	<ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Retorna un nombre enter aleatori dins d'un interval determinat.</ahelp>
04060106.xhp par_id3164758 help.text	RANDBETWEEN(Bottom; Top)	ALEATENTRE(Inferior; Superior)
04060106.xhp par_id7112338 help.text	Returns an integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive).	Retorna un nombre enter aleatori entre els enters <emph>Inferior</emph> i <emph>Superior</emph> (inclosos).
04060106.xhp par_id2855616 help.text	This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.	Aquesta funció genera un nombre aleatori nou cada vegada que el Calc recalcula. Per a forçar manualment que el Calc recalculi, premeu F9.
04060106.xhp par_id2091433 help.text	To generate random numbers which never recalculate, copy cells containing this function, and use <item type="menuitem">Edit - Paste Special</item> (with <item type="menuitem">Paste All</item> and <item type="menuitem">Formulas</item> not marked and <item type="menuitem">Numbers</item> marked).	Per a generar nombres aleatoris que no es tornin a calcular, copieu les cel·les que contenen aquesta funció i utilitzeu <item type="menuitem">Edita ▸ Enganxament especial</item> (amb les opcions <item type="menuitem">Enganxa-ho tot</item> i <item type="menuitem">Fórmules</item> desactivades, i l'opció <item type="menuitem">Nombres</item> activada).
04060106.xhp par_id3164785 help.text	<item type="input">=RANDBETWEEN(20;30)</item> returns an integer of between 20 and 30.	<item type="input">=ALEATENTRE(20;30)</item> retorna un enter entre 20 i 30.
04060106.xhp bm_id461590241346526 help.text	<bookmark_value>random numbers non-volatile; between limits</bookmark_value><bookmark_value>RANDBETWEEN.NV function</bookmark_value>	<bookmark_value>nombres aleatoris no volàtils; entre límits</bookmark_value><bookmark_value>funció ALEATENTRE.NV</bookmark_value>
04060106.xhp hd_id171590240366277 help.text	<variable id="randbetween_nv_1"><link href="text/scalc/01/04060106.xhp#randbetween_nv_1">RANDBETWEEN.NV</link></variable>	<variable id="randbetween_nv_1"><link href="text/scalc/01/04060106.xhp#randbetween_nv_1">ALEATENTRE.NV</link></variable>
04060106.xhp par_id391590240473510 help.text	<ahelp hid="HID_FUNC_RANDBETWEEN_NV">Returns an non-volatile integer random number in a specified range.</ahelp>	<ahelp hid="HID_FUNC_RANDBETWEEN_NV">Retorna un nombre enter aleatori no volàtil en un interval especificat.</ahelp>
04060106.xhp par_id181590240522012 help.text	RANDBETWEEN.NV(Bottom; Top)	ALEATENTRE.NV(Inferior; Superior)
04060106.xhp par_id91590242400917 help.text	Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, when using the <link href="text/scalc/01/recalculate_hard.xhp"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>) and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated.
04060106.xhp par_id151590240999839 help.text	<input>=RANDBETWEEN.NV(20;30)</input> returns a non-volatile integer between 20 and 30.	<input>=ALEATENTRE.NV(20;30)</input> retorna un enter no volàtil entre 20 i 30.
04060106.xhp par_id1001590241005601 help.text	<input>=RANDBETWEEN.NV(A1;30)</input> returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change.	<input>=ALEATENTRE.NV(A1;30)</input> retorna un enter no volàtil entre el valor de la cel·la A1 i 30. La funció es recalcula quan canvia el contingut de la cel·la A1.
04060106.xhp bm_id3164800 help.text	<bookmark_value>RAND function</bookmark_value><bookmark_value>random numbers;between 0 and 1</bookmark_value>	Funció RAND <bookmarkvalue></bookmarkvalue> <bookmarkvalue>nombres aleatoris;entre 0 i 1 </bookmarkvalue>
04060106.xhp hd_id3164800 help.text	<variable id="rand_1"><link href="text/scalc/01/04060106.xhp#rand_1">RAND</link></variable>
04060106.xhp par_id3164829 help.text	<ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp>	<ahelp hid="HID_FUNC_ZUFALLSZAHL">Retorna un nombre aleatori entre 0 i 1.</ahelp>
04060106.xhp par_id3164884 help.text	RAND()	ALEAT()
04060106.xhp par_id5092318 help.text	This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.	Aquesta funció genera un nombre aleatori nou cada vegada que el Calc recalcula. Per a forçar manualment que el Calc recalculi, premeu F9.
04060106.xhp par_id9312417 help.text	To generate random numbers which never recalculate, either:	Per a generar nombres aleatoris que mai no es recalcularan, podeu fer el següent:
04060106.xhp par_id451590242105253 help.text	Copy cells each containing =RAND(), and use <menuitem>Edit - Paste Special</menuitem> (with <emph>Paste All</emph> and <emph>Formulas</emph> not marked and <emph>Numbers</emph> marked).	Copia les cel·les que contenen =ALEAT() i usa <menuitem>Edita ▸ Enganxa especial</menuitem> (amb <emph>Enganxa</emph> <emph>Tot</emph> i <emph>Fórmules</emph> sense marcar i <emph>Nombres</emph> marcat).
04060106.xhp par_id801590242114296 help.text	Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>).	Utilitzeu l'ordre Emplena les cel·les amb nombres aleatoris (<menuitem>Full ▸ Emplena les cel·les ▸ Omple amb nombres aleatoris</menuitem>).
04060106.xhp par_id41590242118383 help.text	Use the RAND.NV() function for non-volatile random numbers.	Utilitzeu la funció RAND.NV() per a nombres aleatoris no volàtils.
04060106.xhp par_id9569078 help.text	<item type="input">=RAND()</item> returns a random number between 0 and 1.	<item type="input">=ALEAT()</item> retorna un nombre aleatori entre 0 i 1.
04060106.xhp bm_id341590241488944 help.text	<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value><bookmark_value>RAND.NV function</bookmark_value>	<unk>GA nombres aleatoris no volàtils;entre 0 i 1</bookmarkvalue><bookmarkvalue>funció RAND.NV </bookmarkvalue>
04060106.xhp hd_id71590238179170 help.text	<variable id="rand_nv_1"><link href="text/scalc/01/04060106.xhp#rand_nv_1">RAND.NV</link></variable>
04060106.xhp par_id101590238875834 help.text	<ahelp hid="HID_FUNC_RAND_NV">Returns a non-volatile random number between 0 and 1.</ahelp>	<ahelp hid="HID_FUNC_RAND_NV">Retorna un nombre aleatori no volàtil entre 0 i 1.</ahelp>
04060106.xhp par_id391590238945182 help.text	RAND.NV()	RAND.NV()
04060106.xhp par_id271590239748534 help.text	This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function or using the <link href="text/scalc/01/recalculate_hard.xhp"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>). The function is recalculated when opening the file.
04060106.xhp par_id191590241215013 help.text	<input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1.	<unk>GA =RAND.NV()</input> retorna un nombre aleatori no volàtil entre 0 i 1.

Loading…

jmontane

Translation uploaded

English

Catalan 105 characters edited Current translation

3 years ago

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Catalan
No related strings found in the glossary.

String information

Context

04060106.xhp
bm_id3164800
help.text

Source string description

odp65

Source string location

04060106.xhp

String age

4 years ago

Last updated

a year ago

Source string age

4 years ago

Translation file

ca/helpcontent2/source/text/scalc/01.po, string 1685