Lambobin Zagaye har zuwa mafi kusa 5 ko 10 a Excel

01 na 01

Ayyukan KASA KASHI

GABATAR GABATAR GABATARWA

Za'a iya amfani da aikin na Excel don kawar da wurare marasa ƙaranci marasa buƙata ko wasu lambobi marasa mahimmanci a cikin bayanai ta hanyar tara lambobin zuwa sama zuwa darajar da ta fi kusa da muhimmanci.

Alal misali, ana iya amfani da aikin don zagaye lamba har zuwa mafi kusa 5, 10, ko wasu ƙayyadadden ƙayyadaddun.

Ƙididdigar lamba zai iya ƙayyade da sauri ta ƙidaya ta lamba. Alal misali, 5, 10, 15, da 20 duka suna da yawa na 5

Ayyukan da ake amfani dashi don aiki shine haɗu da farashin abubuwa zuwa mafi kyawun dime ($ 0.10) don kaucewa samun magance ƙananan canji kamar pennies ($ 0.01) da kuma nickels ($ 0.05).

Lura: Don ƙidaya lambobi ba tare da tantance adadin zagaye ba, yi amfani da aikin ROUNDUP .

Sauya Bayanan tare da Ayyukan Zama

Kamar sauran ayyuka masu tasowa, aikin da ke gudana yana canza bayanan da aka yi a cikin takardar aikinka da kuma so, sabili da haka rinjayar sakamakon kowane lissafi da suke amfani da ƙididdigar ƙira.

Akwai, a daya bangaren, zaɓuɓɓukan tsarawa a cikin Excel da ke ba ka damar canja yawan adadin ƙananan wurare da aka nuna ta bayananka ba tare da canza lambobin da kansu ba.

Yin gyaran canje-canje zuwa bayanai ba shi da tasiri akan lissafi.

Hanyoyin Sakamakon Sakamakon Wuta da Magana

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

Haɗin aikin aikin CEILING shine:

= KYAU (Lamba, Mahimmanci)

Lambar - darajar da za a ɗaura. Wannan hujja na iya ƙunsar ainihin bayanai don tasowa ko yana iya kasancewa tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki.

Muhimmanci - adadin wurare masu kwakwalwa a cikin wannan gardama yana nuna yawan adadin ƙananan wurare ko ƙananan lambobin da zasu kasance a cikin sakamakon (layuka 2 da 3 na misali)
- aikin yana ƙaddamar da ƙidayar Magana da aka ƙayyade a sama har zuwa maɓallin mafi kusa na wannan darajar
- idan an yi amfani da lamba don wannan hujja dukkan wurare masu kyau a cikin sakamakon za a cire kuma sakamakon za a yi zagaye zuwa nau'in mafi yawan wannan darajar (jere na 4 na misali)
- don ƙin Tambayoyi masu yawa da tabbatacciyar mahimmancin muhawarar, sakamakon yana zuwa sama zuwa sama (layuka 5 da 6 na misali)
- don ƙin ƙwararrakin Magana da ƙananan Magana mai mahimmanci , sakamakon da aka zana ƙasa daga zero (jere 7 na misali)

GABATAR GABATAR GABATARWA

Misali a cikin hoton da ke sama yana amfani da aikin na CEILING don zagaye da yawan ƙimar adadi zuwa na gaba har ma da maƙala.

Za'a iya shigar da aikin ta hanyar rubuta sunan aiki da muhawara a cikin tantanin da ake so ko za a iya shiga ta amfani da akwatin maganganun kamar yadda aka tsara a kasa.

Matakan da ake amfani dashi don shigar da aikin zuwa cell C2 sune:

1. Danna maɓallin C2 don sa shi tantanin aiki - wannan shine inda za a nuna sakamakon aikin CEILING
2. Danna maɓallin Formulas na shafin rubutun
3. Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke
4. Danna kan WANNA a cikin jerin don kawo akwatin maganganu na aikin
5. A cikin akwatin maganganu, danna kan Lambar
6. Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu
7. A cikin akwatin maganganu, danna kan Mahimmancin layin
8. Rubuta a cikin 0.1
9. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
10. Amsar 34.3 ya kamata ya bayyana a cell C2
11. Lokacin da ka danna kan tantanin halitta E1 cikakken aikin = KASHI (A2, 0.1) ya bayyana a cikin maɓallin tsari a sama da takardun aiki

Ta yaya Excel ta zo a wannan amsar ita ce:

• da farko ya cire lambar da ba a ƙidayar ba (2) daga ƙarshen lambar - ɗaya daga cikin ƙayyadaddun wuri a cikin Alamar Mahimmanci yana nufin ƙaddara ɗaya ne kawai a sakamakon
• na gaba yana zagaye lambar da ta rage har zuwa 34.3 tun da wannan shine mafi girma mai yawa na 0.10 bayan 34.2

Sakamakon Cell C3 zuwa C7

Idan aka maimaita matakan da ke sama don Kwayoyin C3 zuwa C7, ana samun sakamakon da ake biyowa:

• cell C3 ya ƙunshi darajar 34.25, tun da wurare biyu na ƙaddara a cikin Alamar Alamar yana bukatar wurare biyu na rubiɓuka a cikin sakamakon kuma 34.25 shine mafi girman zabin na 0.05 bayan 34.22
• cell C4 yana ƙunshe da darajar 35, tun da Alamar Alamar alama ce mai lamba, duk ɗayan ƙananan wurare an cire daga sakamakon kuma 35 shine mafi girma na gaba daya na 1 bayan 34
• cell C5 yana ƙunshe da darajar -34.2 saboda waɗannan dalilan da aka tsara don tantanin halitta C2
• cell C6 ya ƙunshi darajar - 34 don wannan dalilai kamar tantanin halitta C4
• cell C7 yana ƙunshe da darajar -35, haɗa nau'i mai mahimmanci da ƙananan lamba don Ƙidar Alamar ta kawar da duk wurare na nakasassuka kuma yana zagaye sakamakon zuwa zuwa na gaba na 1 bayan -34

#NUM! Kuskuren kuskure

# NUM ! Ƙaƙwalwar kuskure ta dawo da shi don aikin CEILING idan an haɗa da ƙwararriyar Ƙwararriyar Magana tare da shaida mai mahimmanci .