Yadda za a samar da Lissafin Lissafi tare da Ayyukan RA na Excel

01 na 01

Ƙirƙirar Ƙimar Dama tsakanin 0 da 1 tare da RAND Function

Wata hanya don samar da lambobi a cikin Excel yana tare da aikin RAND.

Ta hanyar kanta, aikin yana haifar da iyakar iyakokin lambobin bazuwar, amma ta amfani da RAND a cikin tsari da wasu ayyuka, iyakar dabi'un, kamar yadda aka nuna a cikin hoton da ke sama, za a iya fadada sauƙi don haka:

• Ta hanyar ƙaddamar da ƙananan dabi'u da ƙananan lambobi, za'a iya sanya RAND don dawo da lambobin bazuwar a cikin iyakan da aka kayyade - kamar 1 da 10 ko 1 da 100
• Za'a iya rage fitar da kayan aikin ta hanyar haɗuwa ta hanyar haɗin aikin tare da aikin TRUNC , wanda yake ƙaddara ko cire dukkan wuraren adadi daga lamba.

Lura : A cewar fayil na taimakon Excel, aikin RAND ya sake dawo da lambar da ya fi girma ko kuma daidai da 0 da ƙasa da 1 .

Abin da ake nufi shi ne cewa yayin da yake da kyau don bayyana iyakar dabi'un da aka samo daga aikin kamar yadda yake daga 0 zuwa 1, a gaskiya, ya fi dacewa a ce iyakar tsakanin 0 da 0.99999999 ....

A daidai wannan alama, hanyar da ta dawo da lambar bazuwar tsakanin 1 da 10 na ainihi ya dawo darajar tsakanin 0 da 9.999999 ....

Hanyoyin Ginin RAND

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Haɗin aikin aikin RAND shine:

= RAND ()

Ba kamar aikin da yake ba , wanda yake buƙatar ƙididdigar ƙaura da ƙananan ƙaƙƙarfan da za a ƙayyade, aikin RAND ba zai karɓa ba.

RAND Matakan Ayyuka

Da ke ƙasa an jera matakan da ake buƙatar haɓaka misalai da aka nuna a cikin hoto a sama.

1. Na farko ya shiga aikin RAND da kanta;
2. Misali na biyu ya haifar da wata hanyar da ta haifar da lambar bazuwar tsakanin 1 da 10 ko 1 da 100;
3. Misali na uku ya haifar da lambar baƙi tsakanin 1 da 10 ta amfani da aikin TRUNC;
4. Misali na karshe yana amfani da aikin ROUND don rage yawan adadin ƙananan wurare don lambobi bazuwar.

Misali 1: Shigar da aikin RAND

Tun da aikin RAND ba ya da wata hujja, za a iya shigar da shi cikin kowane sashin layi na aiki ta hanyar latsa kan tantanin halitta da rubutu:

= RAND ()

kuma latsa maɓallin shigarwa akan keyboard. Sakamakon zai zama lambar bazuwar tsakanin 0 da 1 a cikin tantanin halitta.

Misali 2: Samar da Lissafin Lissafi tsakanin 1 da 10 ko 1 da 100

Babban nau'i na lissafin da aka yi amfani dashi don samar da lambar bazuwar a cikin wani kewayon ƙayyade shi ne:

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

inda High da Low nuna ƙananan ƙananan ƙananan iyaka na layin da ake buƙata na lambobi.

Don samar da lambar bazuwar tsakanin 1 da 10 shigar da hanyar da aka biyowa a cikin sashin layi:

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

Don samar da lambar bazuwar tsakanin 1 da 100 shigar da wannan ƙira a cikin sashin layi:

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

Misali 3: Samar da Ƙirgiyoyi masu mahimmanci tsakanin 1 da 10

Don dawo da lamba - lamba ɗaya ba tare da wani sashi na ƙayyadadden ƙima ba - babban nau'i na daidaituwa ita ce:

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

Don samar da lambar bazuwar tsakanin 1 da 10 shigar da tsarin da aka biyowa cikin tantanin halitta:

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

RAND da ROUND: Rage Decimals Places

Maimakon cire duk wurare na ƙirar tare da aikin TRUNC, misali na ƙarshe a sama yana amfani da aikin ROUND na gaba tare da RAND don rage yawan adadin ƙananan wurare a cikin bazuwar lamba zuwa biyu.

= ROUND (RAND () * (100-1) +2,2)

RAND Function da Volatility

Ayyukan RAND na ɗaya daga cikin ayyukan da ke cikin Excel. Abin da ake nufi shine:

• Ayyukan ya sake rikodin - yana samar da wani sabon bazuwar - duk lokacin da aikin aiki ya canza, kuma wannan ya haɗa da ayyuka kamar ƙara sabon bayanai.
• Duk wani dabarar da ya dogara - ko dai kai tsaye ko a kaikaice - a kan tantanin halitta wanda ke dauke da wani aiki maras tabbas zai sake rikitawa duk lokacin da canji a cikin takardar aiki yake faruwa.
• A cikin takardun aiki ko littattafan littattafan da ke ɗauke da manyan bayanai, dole ne a yi amfani da ayyuka masu banƙyama tare da taka tsantsan kamar yadda zasu iya jinkirta lokacin amsawa na shirin saboda yawan saukewa.

Fara da Dakatar da Yaren Ƙari tare da F9

Yin tilasta aikin RAND don samar da sababbin lambobi ba tare da yin wasu canje-canje zuwa wani aikin aiki ba za a iya cika ta latsa maɓallin F9 a kan keyboard. Wannan yana aiki da dukan takardun aiki don sake rikodin - ciki har da dukkanin kwayoyin da ke dauke da aikin RAND.

Har ila yau, za a iya amfani da maɓallin F9 don hana lambar bazuwar canzawa duk lokacin da aka canza canjin aiki, ta yin amfani da matakai na gaba:

1. Danna kan tantanin aiki, inda lambar baƙuwar za ta zauna
2. Rubuta aikin = RAND () a cikin wannan tsari a sama da takardun aiki
3. Latsa maɓallin F9 don canza aikin RAND a cikin lambar bazuwar lambobi
4. Latsa maɓallin shigarwa a kan keyboard don shigar da lambar bazuwar cikin cell da aka zaɓa
5. Bugawa F9 ba zata sami tasiri akan lambar bazuwar ba

Aikin Ric Function Dialog Box

Kusan dukkan ayyuka a Excel za a iya shiga ta amfani da akwatin maganganu maimakon shigar da su da hannu. Don yin haka don aikin RAND yayi amfani da matakai na gaba:

1. Danna kan tantanin halitta a cikin takardun aiki inda za a nuna sakamakon sakamakon aikin;
2. Danna kan Rubutun hanyoyin shafin rubutun ;
3. Zabi Math & Trig daga rubutun don buɗe jerin sauƙaƙe aikin;
4. Danna RAND a jerin;
5. Maganar maganganun ta ƙunshi bayani cewa aikin ba shi da wata hujja;
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki;
7. Lambar da ba a ƙira ba tsakanin 0 da 1 ya kamata ya bayyana a tantanin halitta na yanzu;
8. Don samar da wani, danna maɓallin F9 akan keyboard;
9. Lokacin da ka danna kan tantanin halitta E1, cikakken aikin = RAND () ya bayyana a cikin maɓallin tsari a sama da aikin aiki.

Ayyukan RAND a cikin Microsoft Word da PowerPoint

Za'a iya amfani da aikin RAND a wasu shirye-shiryen Microsoft Office, kamar Word da PowerPoint, don ƙara sassan layi na bayanan zuwa wani takarda ko gabatarwa. Wata damar da za a iya amfani da shi don wannan fasalin ita ce abun da ke ciki a cikin samfurori.

Don amfani da wannan fasalin, shigar da aikin daidai wannan hanya a cikin wadannan shirye-shirye kamar yadda a Excel:

1. Danna tare da linzamin kwamfuta a wurin da za a kara rubutu;
2. Rubuta = RAND ();
3. Latsa maɓallin shigarwa a kan keyboard.

Adadin sakin layi na rubutu bazu ya bambanta dangane da fasalin shirin da aka yi amfani dasu. Alal misali, Kalma ta 2013 ta haifar da sassan layi biyar ta hanyar tsoho, yayin da Word 2010 ta haifar da uku kawai.

Don sarrafa adadin rubutun da aka samar, shigar da adadin sassan da ake so a matsayin gardama tsakanin kullun maras.

Misali,

= RAND (7)

zai samar da sassan bakwai a cikin zaɓaɓɓun wuri.