Yadda za a Zauren Lissafi a Excel

Yi amfani da aikin ROUNDUP a Excel zuwa Lissafin Lissafi

Ana amfani da aikin ROUNDUP a Excel don rage darajar ta wani adadi na wurare masu yawa ko wurare. Wannan aikin zai yayata lamarin zuwa sama, kamar 4.649 zuwa 4.65.

Wannan ikon da ke cikin Excel ya canza darajar bayanan a cikin tantanin halitta, ba kamar tsarin tsarawa ba wanda ya ba ka izinin canza yawan adadin ƙananan wurare da aka nuna ba tare da canza ainihin tantanin salula ba. Saboda haka, ana haifar sakamakon sakamakon lissafi.

Lambobi marasa maƙasudin, ko da yake an rage su da darajar da aikin ROUNDUP, an ce za a ɗaure su. Zaka iya ganin wasu misalai a kasa.

Ayyukan ROUNDUP na Excel

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

Wannan shi ne haɗin kan aikin ROUNDUP:

Lambar - (da ake buƙata) 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.

Num_digits - (da ake buƙata) adadin lambobin da za a ɗauka Magana Number zuwa.

• Idan an saita hujjar Num_digits zuwa 0, aikin yana kimanta darajar zuwa lambar mafi kusa;
• Idan aka ƙaddamar da gardama na Num_digits zuwa 1, aikin zai bar kalma guda ɗaya zuwa dama na ƙaddamar da ƙaddamarwa kuma yana zagaye shi zuwa lambar ta gaba;
• Idan hujjar Num_digits ta zama mummunan, an cire dukkan wurare na nakasassu kuma aikin yana ƙididdige yawan adadin lambobi zuwa hagu na ƙimar adadi zuwa sama.

Lura: Domin misali na gardama na ƙarshe, idan an saita darajar lamarin Numba a -2 , aikin zai cire dukkan lambobi zuwa dama na maɓallin decimal kuma zagaye na farko da na biyu digit zuwa hagu na ƙimar decimal har zuwa mafi kusa 100 (kamar yadda aka nuna a jere na shida a misali a sama).

ROUNDUP Abubuwan Ayyuka

Hoton da ke sama yana nuna misalai kuma ya ba da bayani ga yawan sakamako da aka aika ta hanyar ROUNDUP na Excel don bayanai a shafi A na takardar aiki.

Sakamakon, wanda aka nuna a shafi na B , yana dogara akan darajar lamarin Num_digits .

Umarnin da ke ƙasa dalla-dalla matakan da aka ɗauka don rage lambar a cikin salula A2 a cikin hoton da ke sama zuwa wurare biyu na ƙirawa ta amfani da aikin ROUNDUP. A cikin tsari, aikin zai ƙara darajar lambar zagaye ta daya.

Shigar da aikin ROUNDUP

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

• Rubuta cikakken aikin: = ROUNDUP (A2,2) zuwa cikin cell C3 a cikin takardun aiki;
• Zaɓi aikin da muhawara ta amfani da maganganun aikin.

Yin amfani da maganganun ya sauƙaƙe shigar da muhawarar aikin. Tare da wannan hanya, ba lallai ba ne don shigar da rikici a tsakanin kowace muhawarar aikin kamar abin da dole ne a yi a lokacin da aka buga aiki a cikin tantanin halitta - a wannan yanayin tsakanin A2 da 2 .

1. Danna kan C3 ta cell don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon ROUNDUP.
2. Danna maɓallin Formulas na shafin rubutun .
3. Zabi Math & Trig daga ribbon don buɗe jerin abubuwan da aka sauke.
4. Zaɓi ROUNDUP daga jerin don bude akwatin maganganun.
5. Zaɓi akwatin rubutu kusa da "Lambar."
6. Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin salula a cikin akwatin maganganun a matsayin wuri na lambar da za a kewaye.
7. Zaɓi akwatin rubutu kusa da "Num_digits."
8. Rubuta 2 don rage lambar a A2 daga wurare biyar zuwa biyu.
9. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
10. Amsar 242.25 ya kamata ya bayyana a cell C3 .
11. Lokacin da ka danna kan tantanin C2, cikakken aikin = ROUNDUP (A2, 2) yana bayyana a cikin maɓallin tsari a sama da takardun aiki .