01 ntawm 01
Tsim kom muaj Txiaj Ntsig Hauv Nruab Nrab ntawm 0 thiab 1 nrog RAND Function
Ib txoj kev los muab cov zauv random hauv Google Spreadsheets yog nrog RAND muaj nuj nqi.
Los ntawm nws tus kheej, qhov kev ua haujlwm ua rau muaj kev txwv ntau thaum nws los ua kom cov zauv ntawm random, tabsis thaum siv RAND hauv cov qauv thiab los ntawm combing nrog lwm lub zog, qhov ntau ntawm qhov tseem ceeb, raws li muaj nyob hauv daim duab saum toj no tau yooj yim.
- Los ntawm specifying lub siab thiab qis dua qhov tseem ceeb ntawm qhov sib txawv , RAND tuaj yeem ua kom rov xa cov zauv ntawm cov zauv nyob hauv kev teev meej - xws li 1 thiab 10 lossis 1 thiab 100
- Qhov kev ua ntawm cov zis kuj tseem yuav txo tau kom cov zauv los ntawm kev sib txuas nrog cov kev ua haujlwm nrog TRUNC kev ua haujlwm, uas muab cov zauv los yog tshem tag nrho cov zauv ntawm cov zauv.
Ceebtoom : Raws li Google Spreadsheets 'pab file, RAND muaj nuj nqi rov random tooj ntawm 0 inclusive thiab 1 kom .
Qhov no txhais tau tias yog thaum nws yog li ib txwm los piav txog qhov ntau ntawm cov txiaj ntsig ntawm qhov kev ua raws li ntawm 0 mus rau 1, hauv qhov tseeb, nws yog qhov tseeb dua hais qhov ntau yog 0 thiab 0.99999999 ....
Los ntawm tib qhov token, qhov formula uas rov ib qho naj npawb ntawm 1 thiab 10 rov qab ua ib qho txiaj ntsig ntawm 0 thiab 9.999999 ....
RAND Function tus Syntax
Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav cov kev ua haujlwm lub npe, cov ntsiab lus, cov cim cais, thiab cov lus sib tham .
Lub syntax rau RAND muaj nuj nqi yog:
= RAND ()
Tsis zoo li lub RANDBETWEEN muaj nuj nqi, uas yuav tsum tau muaj cov lus kawg thiab tsawg kawg yuav tsum tau teev, lub RAND muaj nuj nqi lees txais tsis pom.
RAND Function thiab Volatility
Txoj kev ua haujlwm RAND yog qhov ua haujlwm tsis muaj zog , uas yog los ntawm kev hloov, lossis pauv txhua zaus ntawm daim ntawv ua haujlwm hloov, thiab cov kev hloov no muaj xws li kev ntxiv cov ntaub ntawv ntxiv.
Tsis tas li ntawd, txhua hom mis uas yog nyob ntawm - ncaj qha los yog tsis ncaj - ntawm ib lub xov tooj ntawm tes uas muaj qhov ua haujlwm tsis tu ncua yuav tau rov qab xam txhua zaus thaum muaj kev hloov hauv daim ntawv ua haujlwm tshwm sim.
Yog li ntawd, hauv daim ntawv khiab tsev uas muaj cov ntaub ntawv ntau, cov neeg ua haujlwm tsis txaus ntseeg yuav tsum siv ceev faj vim lawv tuaj yeem qeeb qhov kev pab cuam lub sij hawm teb vim yog qhov kev rov qab txheeb xyuas dua.
Generating Tshiab Random Numbers nrog Refresh
Txij li thaum Google Spreadsheets yog ib qho kev kawm hauv online, RAND muaj nuj nqi yuav raug yuam kom ua kom muaj cov tshiab cov lej random los ntawm refreshing qhov screen siv lub web browsers refresh khawm. Nyob ntawm qhov browser siv, lub khawm refresh feem ntau yog tus xub xub nyob ze qhov browser qhov chaw nyob.
Qhov thib ob xaiv yog mus nias lub F5 qhov tseem ceeb ntawm cov keyboard uas tseem refreshes qhov rais browser tam sim no:
Hloov RAND's Hloov Hloov Pauv
Hauv Google Spreadsheets, qhov zaus uas RAND thiab lwm yam kev ua haujlwm tsis muaj zog tuaj yeem hloov tau los ntawm lub neej ua ntej hloov mus rau:
- ntawm kev hloov thiab txhua feeb;
- ntawm kev hloov thiab txhua teev.
Cov kauj ruam rau kev hloov kho tshiab yog:
- Nias rau hauv cov ntawv qhia zaub mov kom qhib tau cov lus qhia ntawm cov kev xaiv
- Nias ntawm Spreadsheet Settings nyob rau hauv cov npe kom qhib qhov Spreadsheet Settings dialog box
- Hauv qab seem rov qab ntawm lub thawv ntawv, nyem rau ntawm qhov chaw tam sim no - xws li ntawm kev hloov los qhia tag nrho cov npe ntawm recalculation xaiv
- Nias ntawm qhov kev xaiv ntawm qhov kev xaiv rov qab rau hauv daim ntawv
- Nias ntawm Save Settings khawm kom txuag tau qhov hloov thiab rov qab mus rau hauv daim ntawv
RAND Function piv txwv
Hauv qab no teev cov kauj ruam uas yuav tsum tau muab luam tawm cov qauv hauv daim duab saum toj no.
- Thawj nkag mus rau RAND ua haujlwm ntawm nws tus kheej;
- Qhov thib ob ua piv txwv ib qho qauv uas ua rau random number ntawm 1 thiab 10 lossis 1 thiab 100;
- Piv txwv thib peb ua kom muaj cov cim integer ntawm 1 thiab 10 siv lub TRUNC kev ua haujlwm.
Piv txwv 1: Nkag mus rau hauv RAND Function
Txij thaum RAND muaj nuj nqi yuav siv tsis tau cov lus, nws tau yooj yim muab nkag rau hauv cov lus hauv cell tsab xov xwm tsuas yog sau:
= RAND ()
Xwb, txoj haujlwm tseem tuaj yeem nkag mus siv Google Spreadsheets ' pib-qhia lub thawv uas tawm tuaj raws li lub npe ntawm txoj haujlwm yog ntaus rau hauv xovtooj. Cov kauj ruam yog:
- Nias ntawm ib lub xovtooj rau hauv daim ntawv ua haujlwm uas qhov kev ua haujlwm tau muab coj los tso tawm
- Ntaus tus cim sib npaug (=) raws li lub npe ntawm txoj haujlwm rand
- Thaum koj ntaus ntawv, nws pib lub thawv tshwm nrog cov npe ntawm cov haujlwm uas pib ntawm tsab ntawv R
- Thaum lub npe RAND tshwm nyob rau hauv lub thawv, nyem rau ntawm lub npe nrog tus pointer pointer nkag rau lub npe muaj nuj nqi thiab qhov qhib kev bracket rau hauv lub xov tooj xaiv
- Random tooj ntawm 0 thiab 1 yuav tsum tshwm sim hauv xovtooj tam sim no
- Los ua kom muaj dua lwm tus, nyem qhov F5 yawm sij ntawm cov keyboard los yog rov qhib qhov browser
- Thaum koj nias rau ntawm tes tam sim no, qhov ua tiav tiav = RAND () tshwm nyob hauv qhov qauv mis saum toj sau nplooj ntawv
Piv txwv 2: Generating Random Numbers ntawm 1 thiab 10 lossis 1 thiab 100
Daim ntawv ntawm kab zauv siv los ua kom muaj ib qho xov tooj nyob rau hauv qhov tau teev tseg yog:
= RAND () * (High-Low) + Qes
qhov twg High thiab Low qhia qhov siab thiab qis qis ntawm qhov ntau yam ntawm cov zauv.
Los ua kom muaj tus nab npawb ntawm 1 thiab 10 nkag rau cov qauv hauv qab no rau hauv ib daim ntawv ntawm tes:
= RAND () * (10 - 1) + 1
Los ua kom muaj tus nab npawb ntawm 1 thiab 100 nkag rau cov qauv hauv qab no rau hauv ib daim ntawv ntawm tes:
= RAND () * (100-1) + 1
Piv txwv 3: Generating Random Integers ntawm 1 thiab 10
Xa ib qho zauv - tag nrho cov zauv uas tsis muaj zauv - daim ntawv ntawm kab zauv yog:
= TRUNC (RAND () * (High - Low) + Qis)
Los ua kom muaj kev sib tw ntawm pes tsawg tus 1 thiab 10 nkag rau cov qauv hauv qab no rau hauv ib daim ntawv ntawm tes:
= TRUNC (RAND () * (10 - 1) + 1)