Gudaha Microsoft Excel, shaqada RANDBETWEEN waa Xisaab^(Math) iyo Trigonometry Function , ujeeddadeeduna waa in lagu soo celiyo lambar random inta u dhaxaysa tirooyinka aad sheegtay. Qaabka shaqada RANDBETWEEN waa RANDBETWEEN (bottom, top).

Tababarkan, waxaan ku sharixi doonaa sida loo isticmaalo shaqada RANDBETWEEN . Syntax ee shaqada RANDBETWEEN .

• Gunta : Tijaarka^(Bottom) ugu yar ee shaqada RANDBETWEEN soo noqon doonto. Waa loo baahan yahay.
• Sare^(Top) : Tirada ugu weyn ee shaqada RANDBETWEEN soo noqon doonto. Waa loo baahan yahay.

Sida loo isticmaalo shaqada RANDBETWEEN

Fur Microsoft PowerPoint.

Samee Shax.

Gudaha qolka aad rabto inaad dhigto nooca natiijada =RANDBETWEEN(A2, B2).

A2 waa unugga ka kooban gunta, kaas oo ah tirada ugu yar.

B2 waa unugga ka kooban sare^(Top) , kaas oo ah tirada ugu weyn.

Riix^(Press) geli kiiboodhka si aad u aragto natiijada oo hoos u jiid gacanta buuxinta si aad u aragto jawaabaha kale.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada RANDBETWEEN gudaha Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidixda sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada-hadalka ee qaybta, Dooro Qayb^{(Select a Category)} , ka dooro Xisaab iyo Trig^{(Math and Trig)} sanduuqa liiska.

Qaybta Dooro Function^{(Select a Function)} , ka dooro shaqada RANDBETWEEN liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Qaybta hoose^(Bottom) , geli sanduuqa unugga A2 .

Qaybta lambarka^(Number) , geli sanduuqa unugga B2 .

Kadib guji OK si aad u aragto natiijada.

Habka Labaad waa in la gujiyo tabka Formulas oo aad gujiso ^{(Formulas )}Xisaabta iyo^{(Math and Trig)} Badhanka Badhanka ee kooxda Maktabadda Shaqada^{(Function Library)} .

Liiska, dhagsii RANDBETWEEN .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Raac tillaabooyinka habka koowaad ee  Doodaha Shaqada^{(Function Arguments)} .

Haddii aad hayso su'aalo ku saabsan casharrada, noogu soo sheeg faallooyinka.

Hadda akhri^{(Now read)} : Sida loo isticmaalo shaqada hoose iyo sare ee Excel^{(use the Lower and Upper function in Excel)} si loo beddelo kiiska qoraalka.

How to use the RANDBETWEEN Function In Excel

In Microsoft Excel, the RANDBETWEEN function is a Math and Trigonometry Function, and its purpose is to return a random number between the numbers you specify. The formula for the RANDBETWEEN function is RANDBETWEEN (bottom, top).

In this tutorial, we will explain how to use the RANDBETWEEN function. The Syntax for the RANDBETWEEN function.

• Bottom:  The smallest integer that the RANDBETWEEN function will return. It is required.
• Top: The largest integer that the RANDBETWEEN function will return. It is required.

How to use the RANDBETWEEN function

Open Microsoft PowerPoint.

Create a Table.

In the cell where you want to place the result type =RANDBETWEEN(A2, B2).

A2 is the cell that contains the bottom, which is the smallest integer.

B2 is the cell that contains the Top, which is the largest integer.

Press enter on the keyboard to see the result and drag the fill handle down to see the other answers.

There are two other methods to use the RANDBETWEEN function in Excel.

Method one is to click the fx button on the top left of the excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Math and Trig from the list box.

In the section Select a Function, choose the RANDBETWEEN function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the Bottom section, input into the box the cell A2.

In the Number section, input into the box the cell B2.

Then click OK to see the result.

Method Two is to click the Formulas tab and click the Math and Trig button in the Function Library group.

In the list, click RANDBETWEEN.

A Function Arguments dialog box will appear.

Follow the steps in method one for  Function Arguments.

If you have questions about the tutorial, let us know in the comments.

Now read: How to use the Lower and Upper function in Excel to change the case of Text.

Related posts

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida loo isticmaalo Excel Hyperlink Function

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo PMT Function gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo midoobo oo loo kala saaro unugyada Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo Find and FindB functional in Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga