Iyi dzidzo inotaura nezvekugadzira chirongwa chedisi roller muExcel uye inoshandisa nzira dzekugadzirisa kuratidzira kuratidza chiso chimwe chemaviri.
Dice icharatidza nhamba dzisina kuitika inogadzirwa neRANDBETWEEN basa. Madziro ari pameso anofa anoshandiswa achishandisa Wingdings font. Kubatanidzwa kweUYE , IF, uye OR inoshanda kutonga apo dots inowanikwa mune rimwe nerimwe seki redha. Zvichienderana nehuwandu huwandu hwakagadzirwa neRANDBETWEEN maitiro, mapepa achaonekwa mumasero akakodzera emudha mune pepaji . Dice inogona "kubviswa" kakawanda nekudzokororazve pepa rekushanda
01 ye 09
Excel Dice Roller Tutorial Steps
Matanho ekuvaka Excel Dice Roller ndeaya:
- Kuvaka Dice
- Kuwedzera RANDBETWE BASA
- Izvo Mabasa mushure meDots: Kuwana IYI uye IFI Mabasa
- Iyo Imabasa shure kweDots: Kushandisa IF Function Alone
- Izvo Mabasa mushure meDots: Kuwana IYI uye IFI Mabasa
- Iyo Imabasa mushure meDots: Kunyorera OR uye IF Imabasa
- Rolling the Dice
- Kuvanza RANDBETWE Mabasa
02 of 09
Kuvaka Dice
Matanho ari pasi apa anovhara maitiro ekufambisa anoshandiswa kuratidza pachena chiso chimwe chemaji maviri mupaji rako rekushandisa kuti uite dice mbiri.
Maitiro ekugadzirisa maitiro anoshandiswa anosanganisira kushandura masero eusero, kushandiswa kwema cell, uye kushandura mafudzi emhando uye mashizha.
- Dragodza masero D1 kuJ3
- Isa mutsetse wakakura hwemasero aya kusvika pa25
- Isai hutatu hupamhi hwemasero aya kusvika ku5
- Isai yakananga kushandiswa kwemasero kunzvimbo
- Ita vertical cell alignment pakati
- Isa gwaro retaiti kuWingdings
- Ita hukuru hwemafaira kusvika ku30
Disivara
- Dragodza masero D1 kusvika kuF3
- Isa kara yemusero kwebhuruu
- Dragodza masero H1 kusvika kuJ3
- Isa girasi remukati chemasero kuti rive rakatsvuka
03 of 09
Kuwedzera RANDBETWE BASA
Iyo RANDBETWE basa rinoshandiswa kuunza nhamba dzisinganzwisisiki dzinoratidzirwa pamataviri maviri.
For the First Die
- Dzvanya pane cell E5.
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi.
- Dzvanya paRANDBETWE mune urongwa kuti ubudise bhokisi rebasa rebasa.
- Dzvanya pamutsara we "Pasi" mubhokisi rebhokisi.
- Tora nhamba 1 (imwe) pane iyi mutsara.
- Dzvanya pamutsara we "Top" mubhokisi rebhokisi.
- Tora nhamba 6 (nhanhatu) pane iyi mutsara.
- Dzvanya OK.
- Nhamba isinganzwisisiki pakati pe1 ne6 inofanira kuonekwa muchitokisi E5.
For the Second Die
- Dzvanya pane sero I5.
- Dzokorora matanho 2 kusvika ku 9 kumusoro.
- Nhamba isina kuverengwa pakati pe1 ne6 inofanira kuonekwa muchitokisi I5.
04 of 09
Iyo Imabasa shure kweDots (# 1)
Mumasero D1 uye F3 chinyora basa rinotevera:
= IF ((E5> = 2, E5 <= 6), "l", "")
Iri basa rinoedza kuone kana nhamba dzisinganzwisisiki muchitsetse E5 iri pakati pe2 ne6. Kana zvakadaro, inoisa "l" mumasero D1 naF3. Kana zvisina kudaro, inosiya masero asina chinhu ("").
Kuti uwane mugumisiro wakafanana wechipiri kufa, mumasero H1 neJ3 chengetedza basa:
= IF ((I5> = 2, I5 <= 6), "l", "")
Yeuka: Tsamba "l" (lowercase L) inotsvaga muWingdings font.
05 of 09
Iyo Imabasa mushure meDots (# 2)
Mumasero D2 uye F2 chengetedza basa rinotevera:
= IF (E5 = 6, "l", "")
Iri basa rinoedza kuone kana nhamba dzisinganzwisisiki muchitsetse E5 zvakaenzana ne 6. Kana zvakadaro, inopa "l" mumasero D2 uye F23. Kana zvisina kudaro, inosiya sero isina chinhu ("").
Kuti uwane mugumisiro wakafanana wechipiri kufa, mumasero H2 neJ2 chengetedza basa:
= IF (I5 = 6, "l", "")
Yeuka: Tsamba "l" (lowercase L) inotsvaga muWingdings font.
06 of 09
Iyo Imabasa shure kweDots (# 3)
Mumasero D3 uye F1 chinyora basa rinotevera:
= IF ((E5> = 4, E5 <= 6), "l", "")
Iri basa rinoedza kuone kana nhamba dzisinganzwisisiki muchitsetse E5 iri pakati pe4 ne6. Kana zvakadaro, inoisa "l" mumasero D1 naF3. Kana zvisina kudaro, inosiya masero asina chinhu ("").
Kuti uwane mugumisiro mumwechete we wechipiri kufa, mumasero H3 neJ1 chengetedza basa:
= IFI (NE (I5> = 4, I5 <= 6), "l", "")
Yeuka: Tsamba "l" (lowercase L) inotsvaga muWingdings font.
07 of 09
Iyo Imabasa shure kweDots (# 4)
Muchitokisi E2 chinyora basa rinotevera:
= IF (OR (E5 = 1, E5 = 3, E5 = 5), "l", "")
Iri basa rinoedza kuona kana nhamba dzisinganzwisisiki muchitsetse E2 yakaenzana ne1, 3, kana 5. Kana zvakadaro, inoisa "l" muchitokisi E2. Kana zvisina kudaro, inosiya sero isina chinhu ("").
Kuti uwane mugumisiro wakafanana wechipiri kufa, muchitokisi I2 chinyorwa basa:
= (I (OR (I5 = 1, I5 = 3, I5 = 5), "l", ""
Yeuka: Tsamba "l" (lowercase L) inotsvaga muWingdings font.
08 of 09
Rolling the Dice
Kuti "tunganidze" dice, tanidza f 9 F kibhokisi.
Kuita izvi, kunokonzera Excel kubatanidza mabasa ese uye mazano mubasa rekushanda . Izvi zvichaita kuti RANDBETWEEN inoshanda mumasero E5 uye I5 kuti iite imwe nhamba dzisinganzwisisiki pakati pe1 ne6.
09 of 09
Kuvanza RANDBETWE PENYU
Kana imwe dice ichinge yakwana uye mabasa ose akaedzwa kuti ave nechokwadi chokuti vari kushanda zvakanaka, RANDBETWE inoshanda mumasero E5 uye I5 inogona kuvanzwa.
Kuvanza mabasa ichinhu chinokodzera. Kuita kudaro kunowedzera kune "chakavanzika" chekuti dice roller inoshanda sei.
Kuvanza RANDBETWE Mabasa
- Dragodza masero E5 kusvika I5.
- Shandura ruvara rwemhando dzemasero aya kuti afanane nemuvara wekupedzisira. Muchiitiko ichi, shandura kuti "chichena".