Google Spreadsheets 'RAND Ntchito: Pangani Ma random Numeri

01 ya 01

Pangani Phindu Labwino Pakati pa 0 ndi 1 ndi RAND Ntchito

Njira imodzi yobweretsera manambala mu Google Spreadsheets ili ndi ntchito RAND.

Pokhapokha, ntchitoyo imapanga malire ochepa pokhudzana ndi kupanga nambala zosawerengeka, koma pogwiritsira ntchito RAND mu maonekedwe komanso poziphatikiza ndi ntchito zina, miyezo yamtunduwu, monga momwe zasonyezedwera mu chithunzi pamwambapa zikhoza kufalikira mosavuta.

• Pogwiritsa ntchito mfundo zapamwamba komanso zochepa zazitali , RAND ikhoza kupangidwa kuti abwerere chiwerengero chosavuta mwachindunji - monga 1 ndi 10 kapena 1 ndi 100
• Zomwe zimagwira ntchito zimatha kuchepetsedwa kukhala ochepa mwa kuphatikiza ntchito ndi TRUNC ntchito, yomwe imadula kapena kuchotsa malo onse osungira kuchokera ku chiwerengero.

Zindikirani : Malinga ndi fayilo lothandizira la Google Spreadsheets, ntchito ya RAND imabweretsera nambala yosawerengeka pakati pa 0 kuphatikizapo 1 yokha .

Izi zikutanthawuza kuti ngakhale kuti mwachizoloŵezi kufotokozera miyeso yambiri yomwe imapangidwa ndi ntchito monga kuyambira 0 mpaka 1, moona, ndizomveka kunena kuti kusiyana kuli pakati pa 0 ndi 0.99999999 ....

Mwachiwonetsero chomwecho, njira yomwe imabweretsera nambala yosawerengeka pakati pa 1 ndi 10 imabweretsanso mtengo pakati pa 0 ndi 9.999999 ....

Syntax ya RAND Function

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito ya RAND ndi:

= RAND ()

Mosiyana ndi RANDBETWEEN ntchito, yomwe imakhala ndi mfundo zazikulu komanso zotsika zotsimikizirika, ntchito ya RAND sichimvetseratu zotsutsana.

Ntchito ya RAND ndi Kusakhazikika

Ntchito ya RAND ndi ntchito yosasinthasintha yomwe, posasintha, imasintha kapena kubwereza nthawi zonse pamene tsamba likusintha, ndipo kusintha kumeneku kumaphatikizapo zochita monga kuwonjezera kwa deta yatsopano.

Komanso, njira iliyonse yomwe imadalira - kaya mwachindunji kapena mwachindunji - mu selo yomwe ili ndi ntchito yosasinthasintha idzakhalanso kubwereza nthawi iliyonse kusintha kwa tsambali likuchitika.

Choncho, m'mabuku olemba okhala ndi deta zambiri, ntchito zowonongeka ziyenera kukhala zogwiritsa ntchito mosamala pamene zikhoza kuchepetsa nthawi yowonjezera pulojekiti chifukwa cha kuwerengedwa kwafupipafupi.

Kupanga Zatsopano Zowonongeka ndi Refresh

Popeza Google Spreadsheets ndi pulogalamu ya pa intaneti, ntchito ya RAND ikhoza kukakamizika kupanga ziwerengero zatsopano mwazitsitsimutsa chinsalucho pogwiritsa ntchito webusaiti yazamasamba. Malinga ndi osatsegula omwe amagwiritsidwa ntchito, botani lazotsitsimula kaŵirikaŵiri ndilovilo lozungulira lomwe liri pafupi ndi barani ya adiresi.

Njira yachiwiri ndiyokulumikizira f5 key pa kibokosilo yomwe imatsitsimutsanso mawindo osatsegula omwe ali pakali pano:

Kusintha kwa RAND's Refresh Frequency

Mu Google Spreadsheets, nthawi yomwe RAND ndi ntchito zina zowonongeka zimatha kusinthidwa kuchokera kusasinthika kusintha kwa:

• pa kusintha ndi miniti iliyonse;
• pa kusintha ndi ola lililonse.

Zosintha zosinthika ndizi:

1. Dinani pa Fayilo menyu kuti mutsegule mndandanda wa zosankha
2. Dinani pa Zowonjezera Zamagawo m'ndandanda kuti mutsegule bokosi la Mafotokozedwe la Spreadsheet
3. Pansi pa gawo la Recalculation la bokosi la bokosi, dinani pakali pano - monga kusintha kusonyeza mndandanda wathunthu wa zokumbukira zosankha
4. Dinani pa chofunikiranso chofunikiranso mundandanda
5. Dinani pa batani Pulogalamu Zosungira kuti musunge kusintha ndikubwerera kuntchito

ZOYENERA KUGWIRITSA NTCHITO ZOCHITA

M'munsimu muli zofunikira zofunikira kuti mubweretse zitsanzo zomwe zawonetsedwa pa chithunzi pamwambapa.

1. Woyamba akulowa mu RAND ntchito yokha;
2. Chitsanzo chachiwiri chimapanga ndondomeko yomwe imapanga chiwerengero chosasintha pakati pa 1 ndi 10 kapena 1 ndi 100;
3. Chitsanzo chachitatu chimapanga chiwerengero chokhazikika pakati pa 1 ndi 10 pogwiritsa ntchito TRUNC ntchito.

Chitsanzo 1: Kulowa ntchito ya RAND

Popeza kuti ntchito ya RAND imakhalabe ndi zifukwa, zingatheke mosavuta mu selo lopiritsika la ntchito polemba:

= RAND ()

Mwinanso, ntchitoyi ingalowenso pogwiritsira ntchito bokosi la Google Spreadsheets 'lolozera mothandizira lomwe limatuluka pamene dzina la ntchitoyi likuyimikidwa mu selo. Masitepe ndi awa:

1. Dinani pa selo muzenera komwe zotsatira za ntchito ziyenera kuwonetsedwa
2. Lembani chizindikiro chofanana (=) chotsatira dzina la ntchito rand
3. Pamene mukuyimira, bokosi lopangira okhalo likuwoneka ndi mayina a ntchito zomwe zimayamba ndi kalata R
4. Pamene dzina la RAND likupezeka m'bokosilo, dinani pa dzina ndi phokoso la mouse kuti mulowetse dzina la ntchito ndi makina otseguka mu selo losankhidwa
5. Nambala yosawerengeka pakati pa 0 ndi 1 iyenera kuonekera mu selo yamakono
6. Kuti mupange winayo, yesani fisi ya F5 pa kambokosi kapena mukatsitsimutse osatsegula
7. Mukamalemba pa selo yamakono, ntchito yonse = RAND () ikuwoneka mu barra yazenera pamwamba pa tsamba

Chitsanzo chachiwiri: Kupanga Ma random Numeri pakati pa 1 ndi 10 kapena 1 ndi 100

Maonekedwe onse a equation omwe amagwiritsidwa ntchito popanga nambala yosadziwika mwachindunji ndiyi:

= RAND () * (High-Low) + Low

kumene Kumwamba ndi Kutsika kumatanthauza malire apamwamba ndi apansi a manambala omwe mukufuna.

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 10 kulowetsani ndondomeko zotsatirazi mu selo lamasamba:

= RAND () * (10 - 1) + 1

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 100 kulowa mndandanda wotsatirayi mu selo lamasamba:

= RAND () * (100 - 1) + 1

Chitsanzo chachitatu: Kupanga Ma Random Integers pakati pa 1 ndi 10

Kubwezera chiwerengero - chiwerengero chonse chopanda gawo - gawo lonse la equation ndi:

= TRUNC (RAND () * (High-Low) + Low)

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 10 kulowetsani ndondomeko zotsatirazi mu selo lamasamba:

= TRUNC (RAND () * (10 - 1) + 1)