Ta yaya za a Zama Lissafin Ƙidaya a Excel Tare da Sakamakon RUNDOWN

01 na 01

Ayyukan Excel ta ROUNDDOWN

Ayyukan ROUNDOWN:

• Ana amfani dashi don rage darajar ta wani adadin lambobi na wurare marasa kyau ko lambobi;
• za su ci gaba da kasancewa daidai da lamarin;
• ya canza darajar bayanai a cikin tantanin halitta - ba kamar tsarin tsarawa wanda ya ba ka izinin canza yawan adadin wurare da aka nuna ba tare da canza ainihin ƙimar salula ba;
• yana rinjayar sakamakon lissafi saboda wannan canji a cikin bayanai.
• ko da yaushe zane zuwa zero. Lambobi marasa mahimmanci, koda yake suna da karfin darajar ta aikin, ana kiran su sun kasance masu tasowa - kamar yadda aka nuna a misalai a cikin layuka biyar da shida a cikin hoto a sama).

Ƙungiyar Harkokin Gwaninta da Magana

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

Rigon don aikin ROUNDDOWN shine:

= ROUNDOWN (Number, Num_digits)

Magana akan aikin shine:

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 lamba mafi kusa
• idan aka ƙaddamar da gardama na Num_digits zuwa 1, aikin zai bar kalma guda ɗaya zuwa dama na maɓallin decimal kuma ya zagaya zuwa zuwa na gaba.
• idan lamarin Num'digits ya zama mummunan, an cire dukkan wurare na nakasassu kuma aikin yana zagaye da adadin lambobi zuwa hagu na ƙimar decimal zuwa zane
  • Alal misali, idan an ƙaddamar da gardama na lambobi zuwa -2 , aikin zai cire dukkan lambobi zuwa dama na maɓallin decimal kuma zagaye na farko da na biyu lambobi zuwa hagu na ƙananan ƙira zuwa zuwa mafi kusa 100 kamar yadda aka nuna a cikin misali a jere 6 a cikin hoton da ke sama

GABATARWA Sakamakon Ayyuka

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

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 ROUNDDOWN. Saboda aikin da ke faruwa akai, lamarin ba zai canza ba.

Shigar da aikin GABA

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

• Rubuta cikakken aikin: = ROUNDOWN (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 kowane maganganun aiki kamar yadda dole ne a yi a lokacin da aikin ya shiga cikin tantanin halitta - a wannan yanayin tsakanin A2 da 2.

Matakan da ke ƙasa da rufe shigar da aikin ROUNDDOWN ta amfani da akwatin maganganu.

1. Danna kan C3 ta cell don sanya shi tantanin halitta - wannan shine inda za a nuna sakamakon ROUNDDOWN;
2. Danna maɓallin Formulas na shafin ribbon ;
3. Zabi Math & Trig daga rubutun don buɗe jerin sauƙaƙe aikin;
4. Danna ROUNDDOWN a jerin don kawo akwatin maganganu na aikin;
5. A cikin akwatin maganganu danna Lambar waya;
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. Danna kan layi Num_digits ;
8. Rubuta biyu "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 567.96 ya kamata ya bayyana a cell C3;
11. Lokacin da ka danna kan tantanin halitta C2 cikakken aikin = ROUNDOWN (A2, 2) yana bayyana a cikin maɓallin tsari a sama da takardun aiki .