Excel Dov Dice Tutorial

Cov ntawv nyeem no qhia txog yuav ua li cas los tsim kom tau ib qhov kev pab cuam rau cov neeg ua haujlwm hauv Excel thiab siv cov kev xa tawm los teeb ntawm ib lub ntsej muag ntawm ib tus neeg tawm tsam.

Lub tsuav yuav tso tawm ib tug xov tooj ntawm cov zauv ntawm RANDBETWEEN . Cov dots ntawm tuag lub ntsej muag yog tsim siv lub Wingdings font. Ib qho kev sib txuas ntawm THIAB , YOG HAIS LUS , thiab LOSSIS ua haujlwm tswj thaum pom tshwm sim hauv txhua lub xov tooj ntawm cov tsom. Nyob ntawm cov xov tooj ntawm cov zauv ntawm RANDBETWEEN ua hauj lwm, cov dots yuav tshwm nyob rau hauv cov tsaj tsim nyog ntawm cov tsuav nyob hauv daim ntawv ua haujlwm . Tsuav tau "dov" dua los ntawm recalculating cov ntawv ua haujlwm

01 ntawm 09

Excel Dice Roller Tutorial Steps

Cov kauj ruam los tsim kom tau ib qho Excel Dice Menyuam yog raws li nram no:

1. Tsim lub Tsuav
2. Ntxiv RANDBETWEEN Function
3. Qhov Functions qab Cov Dots: Zes lub THIAB THIAB YOG HAIS TIAS
4. Cov Kev Ua Hauj Lwm Tom Qab Cov Dots: Siv qhov Yuam Kev Muaj Ib Leeg
5. Qhov Functions qab Cov Dots: Zes lub THIAB THIAB YOG HAIS TIAS
6. Cov Kev Ua Hauj Lwm Tom Qab Dots: Zes Ua LOS YOG HAIS LUS THIAB YOG HAIS TIAS
7. Dov lub Tsuav
8. Ntaus cov RANDBETWEEN kev ua haujlwm

02 ntawm 09

Tsim lub Tsuav

Cov kauj ruam hauv qab no qhia txog cov txheej txheem kev siv los siv rau ntawm ib lub ntsej muag ntawm ib kab ntawm cov ntawv pov thawj hauv koj daim ntawv ua haujlwm kom tsim tau ob lub yeeb koob.

Txoj kev siv cov formatting yog siv hloov qhov loj ntawm lub cell, sib tw ntawm tes, thiab hloov hom font thiab loj.

• Tsav xaiv hlwb D1 rau J3
• Teem kab qhov siab ntawm cov hlwb no rau 25
• Teem lub kem dav ntawm cov hlwb mus rau 5
• Teem kab rov tav ntawm lub xov tooj ntawm tes
• Teem txoj kev sib dhos ntawm cov xovtooj sib txuas rau nruab nrab
• Teem hom font rau Wingdings
• Teem lub font loj mus rau 30

Tsuav tsos nqaij daim tawv

1. Tsav xaiv hlwb D1 rau F3
2. Teem lub cell background xim rau xiav
3. Drag xaiv hlwb H1 rau J3
4. Teem lub xov tooj ntawm tes tom qab xim liab

03 ntawm 09

Ntxiv RANDBETWEEN Function

RANDBETWEEN kev ua haujlwm yog siv los ua kom muaj cov zauv ntawm cov kis ntawm ob lub npuas.

Rau Thawj Tuag

1. Nyem ntawm tes E5.
2. Nias rau ntawm tus qauv tab ntawm daim ntawv tais cai .
3. Xaiv Math & Trig los ntawm txoj hlua qhib qhov kev ua cim poob npe.
4. Nias ntawm RANDBETWEEN nyob rau hauv daim ntawv los coj mus rau cov kev ua haujlwm hauv lub thawv.
5. Nias ntawm kab "Hauv qab" nyob rau hauv lub thawv ntawv.
6. Sau tus naj npawb 1 (ib qho) rau ntawm kab no.
7. Nias ntawm kab "saum toj" hauv lub thawv ntawv.
8. Sau tus naj npawb 6 (rau) ntawm kab no.
9. Nyem OK.
10. Random tooj ntawm 1 thiab 6 yuav tsum tshwm sim ntawm E5.

Rau lub Tuag Ob

1. Nyem ntawm tes I5.
2. Rov ua li cov kauj ruam 2 mus rau 9 saum toj no.
3. Random tooj ntawm 1 thiab 6 yuav tsum tshwm nyob rau ntawm I5.

04 ntawm 09

Qhov Functions qab qhov Dots (# 1)

Hauv hlwb D1 thiab F3 ntaus cov haujlwm nram no:

= YOG (THIAB (E5> = 2, E5 <= 6), "l", "")

Cov kev ntsuam xyuas no pom tias yog tus lej hauv E5 ntawm nruab nrab ntawm 2 thiab 6. Yog tias muaj, nws muab "l" hauv hlwb D1 thiab F3. Yog tias tsis yog, nws tawm hauv lub hlwb dawb ("").

Tau tib lub txiaj ntsig kev tuag zaum ob, hauv hlwb H1 thiab J3 hom kev ua haujlwm:

= YOG (THIAB (I5> = 2, I5 <= 6), "l", "")

Nco ntsoov: Tsab ntawv "l" (lowercase L) yog ib qho teev hauv Wingdings font.

05 ntawm 09

Lub Functions qab cov Dots (# 2)

Hauv hlwb D2 thiab F2 hom ua haujlwm nram qab no:

= YOG (E5 = 6, "l", "")

Cov kev ntsuam xyuas kev ua haujlwm no yog pom tias tus lej hauv cell E5 yog sib npaug rau 6. Yog tias muaj, nws muab qhov "l" hauv hlwb D2 thiab F23. Yog tsis yog, nws tawm ntawm lub voj voos ("").

Tau tib lub txiaj ntsig rau qhov thib ob tuag, hauv H2 thiab J2 hom kev ua haujlwm:

= YOG (I5 = 6, "l", "")

Nco ntsoov: Tsab ntawv "l" (lowercase L) yog ib qho teev hauv Wingdings font.

06 ntawm 09

Lub Functions qab cov Dots (# 3)

Hauv hlwb D3 thiab F1 hom ua haujlwm nram qab no:

= YOG (THIAB (E5> = 4, E5 <= 6), "l", "")

Cov kev ntsuam xyuas no pom tias yog tus lej hauv E5 ntawm nruab nrab ntawm 4 thiab 6. Yog tias muaj, nws muab qhov "l" hauv hlwb D1 thiab F3. Yog tias tsis yog, nws tawm hauv lub hlwb dawb ("").

Txhawm rau tib qhov raug rau kev tuag zaum ob, hauv hlwb H3 thiab J1 hom kev ua haujlwm:

= YOG (THIAB (I5> = 4, I5 <= 6), "l", "")

Nco ntsoov: Tsab ntawv "l" (lowercase L) yog ib qho teev hauv Wingdings font.

07 ntawm 09

Qhov Functions qab qhov Dots (# 4)

Hauv Cell E2 hom ua haujlwm nram qab no:

= YOG (LOS YOG (E5 = 1, E5 = 3, E5 = 5), "l", "")

Cov kev ntsuam xyuas no yog pom tias tus xov tooj hauv E2 yog sib npaug ntawm 1, 3, los yog 5. Yog tias muaj, nws muab qhov "l" rau hauv E2. Yog tsis yog, nws tawm ntawm lub voj voos ("").

Txhawm rau tib qhov raug rau kev tuag zaum ob, hauv I2 hom kev ua haujlwm:

= YOG HAIS (LOS YOG (I5 = 1, I5 = 3, I5 = 5), "l", "")

Nco ntsoov: Tsab ntawv "l" (lowercase L) yog ib qho teev hauv Wingdings font.

08 ntawm 09

Dov lub Tsuav

Kom "yob" qhov tsuav, nias lub F 9 ntawm tus keyboard.

Ua qhov no, ua rau Excel rov ntsuas tag nrho cov kev ua haujlwm thiab cov qauv hauv daim ntawv khomob . Qhov no yuav ua rau lub RANDBETWEEN kev khiav dej num hauv hlwb E5 thiab I5 los ua kom muaj lwm tus lej random ntawm 1 thiab 6.

09 ntawm 09

Ntaus lub RANDBETWEEN Function

Thaum twg tus tsuav tiav lawm thiab tag nrho cov haujlwm tau raug kuaj xyuas kom lawv ua haujlwm kom raug, RANDBETWEEN functions hauv hlwb E5 thiab I5 yuav raug muab zais.

Ntaus cov dej num yog ib qho kauj ruam uas xaiv tau. Ua li ntawd, ntxiv rau qhov "paub tsis meej" ntawm qhov cov neeg ua haujlwm rau cov neeg ua haujlwm ua haujlwm li cas.

Mus nkaum lub RANDBETWEEN Functions

1. Tsav xaiv hlwb E5 rau I5.
   
2. Hloov xim xim ntawm cov hlwb kom phim xim tom qab. Hauv qhov no, hloov nws kom "dawb".