Kuskuren Excel Rolling Dice Tutorial

Wannan koyaswar ta shafi yadda za a ƙirƙirar wani abin kirki a cikin Excel kuma yana amfani da fasaha don tsara hoto don nuna fuska guda ɗaya na ɗayan haɓaka.

Dice zai nuna lambar da ba ta samo asali daga aikin RANDBETWEEN ba. Ana sanya dots a kan fuskoki masu mutuwa ta yin amfani da layin Wingdings. A hade DA AND , IF, da kuma OR ayyuka sarrafawa lokacin da dige bayyana a cikin kowane cell na dice. Dangane da lambobin da aka ƙayyade da ayyukan RANDBETWEEN, dots zasu bayyana a cikin sel masu dacewa da ƙuƙwalwar a cikin takardun aiki . Za'a iya "yada" dice akai-akai ta hanyar rikodin aikin aiki

01 na 09

Shirin Tutorial Del Rice Tutorial

Matakan da za a gina Del Rice Del sune kamar haka:

1. Gina Dice
2. Ƙara RANDBETWEEN aikin
3. Ayyuka a bayan Dots: Nesting da AND da IF ayyuka
4. Ayyuka a bayan Dots: Amfani da IF Sakamakon Ɗawainiya
5. Ayyuka a bayan Dots: Nesting da AND da IF ayyuka
6. Ayyuka a bayan Dots: Nesting da OR da IF ayyuka
7. Yarda da Dice
8. Hudu da ayyukan da aka yi

02 na 09

Gina Dice

Matakan da ke ƙasa suna rufe shafukan tsarawa da aka yi amfani dasu don nuna fuska guda ɗaya na wani ɗan kwando a cikin takardar aikinku don ƙirƙirar dice guda biyu.

Tsarin hanyoyin tsarawa sun haɗa da canza yawan tantanin tantanin halitta, tantancewar tantanin halitta, da sauya nau'i da nau'in nau'i.

• Jawo zaɓi Kwayoyin D1 zuwa J3
• Saita jeri na tsawo na waɗannan kwayoyin zuwa 25
• Sanya kusurwar shafi na waɗannan sel zuwa 5
• Saita jeri na kwance a tsakiya zuwa cibiyar
• Saita jigon tantanin halitta a tsakiya zuwa tsakiya
• Sanya irin nau'in rubutu zuwa Wingdings
• Saita girman rubutu zuwa 30

Dice launi

1. Jawo zaɓi Kwayoyin D1 zuwa F3
2. Saita tantanin halitta ta launi zuwa blue
3. Jawo zaɓi Hels H1 zuwa J3
4. Saita launin tantanin halitta zuwa ja

03 na 09

Ƙara RANDBETWEEN aikin

Ana amfani da aikin RANDBETWEEN don samar da lambobin da aka nuna a kan dice guda biyu.

Ga Mutuwa na farko

1. Danna kan salula E5.
2. Danna maɓallin Formulas na shafin rubutun .
3. Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke.
4. Danna RANDBETWEEN cikin jerin don kawo akwatin maganganu na aikin.
5. Danna maɓallin "Ƙasa" a cikin akwatin maganganu.
6. Rubuta lambar 1 (ɗaya) akan wannan layi.
7. Danna kan "Rukunin" a cikin akwatin maganganu.
8. Rubuta lambar 6 (shida) akan wannan layi.
9. Danna Ya yi.
10. Lambar da ba a taɓa ba tsakanin 1 da 6 ya kamata ya bayyana a cikin tantanin halitta E5.

Ga mutuwar ta biyu

1. Danna kan tantanin I5.
2. Yi maimaita matakai 2 zuwa 9 a sama.
3. Lambar da ba a lasafta tsakanin 1 da 6 ya kamata ya bayyana a cell I5.

04 of 09

Ayyukan da ke Buga Dots (# 1)

A cikin sassan D1 da F3 sunyi aiki da haka:

= IF (DA (E5> = 2, E5 <= 6), "l", "" "

Wannan aikin yana gwada idan lambar bazuwar a cikin cell E5 tsakanin 2 da 6. Idan haka ne, yana sanya "l" a cikin sel D1 da F3. In ba haka bane, zai bar jigilar sel ("").

Don samun sakamako guda daya don mutuwar na biyu, a cikin sassan H1 da J3 rubuta aikin:

= IF (DA (I5> = 2, I5 <= 6), "l", "" "

Ka tuna: harafin "l" (ƙananan L) wani dot ne a cikin layin Wingdings.

05 na 09

Ayyuka a Gidan Dots (# 2)

A cikin sassan D2 da F2 irin waɗannan ayyuka:

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

Wannan aikin yana gwada idan lambar da aka bazu a cikin cell E5 daidai yake da 6. Idan haka ne, yana sanya "l" a cikin sel D2 da F23. Idan ba haka bane, sai ya bar layin salula ("").

Don samun wannan sakamakon don mutuwar na biyu, a cikin sassan H2 da J2 irin aikin:

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

Ka tuna: harafin "l" (ƙananan L) wani dot ne a cikin layin Wingdings.

06 na 09

Ayyukan da ke Buga Dots (# 3)

A cikin sassan D3 da F1 sunyi aiki da haka:

= IF (DA (E5> = 4, E5 <= 6), "l", "" "

Wannan aikin yana gwada idan lambar da aka ƙidaya a cikin cell E5 tsakanin 4 da 6. Idan haka ne, yana sanya "l" a cikin sel D1 da F3. In ba haka bane, zai bar jigilar sel ("").

Don samun wannan sakamakon don mutuwa ta biyu, a cikin sassan H3 da J1 rubuta aikin:

= IF (AND (I5> = 4, I5 <= 6), "l", "" "

Ka tuna: harafin "l" (ƙananan L) wani dot ne a cikin layin Wingdings.

07 na 09

Ayyuka a Gashin Dots (# 4)

A cikin cell E2 rubuta irin wannan aiki:

= IF (OR (E5 = 1, E5 = 3, E5 = 5), "l", "")

Wannan aikin yana gwada idan lambar da aka bazu a cikin cell E2 daidai yake da 1, 3, ko 5. Idan haka ne, yana sanya "l" a cikin cell E2. Idan ba haka bane, sai ya bar layin salula ("").

Don samun wannan sakamakon don na biyu ya mutu, a cell I2 rubuta aikin:

= IF (OR (I5 = 1, I5 = 3, I5 = 5), "l", "" "

Ka tuna: harafin "l" (ƙananan L) wani dot ne a cikin layin Wingdings.

08 na 09

Yarda da Dice

Don "mirgine" dice, danna maɓallin F 9 akan keyboard.

Yin wannan, yana sa Excel ya sake tattara dukkan ayyuka da ƙididdiga a cikin takarda . Wannan zai haifar da ayyukan RASBETWEEN a cikin kwayoyin E5 da I5 don samar da wani lambar bazuwar tsakanin 1 da 6.

09 na 09

Gudun WANNAN Sakamakon

Da zarar dice ya cika kuma an gwada duk ayyukan don tabbatar da cewa suna aiki daidai, za a iya ɓoye RANDBETWEEN aiki a cikin kwayoyin E5 da I5.

Hanya ayyuka yana da matakan zaɓi. Yin haka yana kara da "asiri" na yadda yadin alamar ke aiki.

Don boye ayyukan ayyuka

1. Jawo zaɓi Kwayoyin E5 zuwa I5.
   
2. Canja launin launi na waɗannan sel don dace da launin launi. A wannan yanayin, canza shi zuwa "fararen".