Hada ROUND da SUM ayyuka a Excel

Hada hada-hadar ayyuka biyu ko fiye - kamar ROUND da SUM - a cikin takamammen guda ɗaya a Excel ana kiran su ayyuka ne .

Nesting an cika ta hanyar aiki daya aiki a matsayin hujja don aikin na biyu.

A cikin hoto a sama:

Hada ROUND da SUM ayyuka a Excel

Tun da Excel 2007, yawan nauyin matakan da za a iya kwance a cikin juna shine 64.

Kafin wannan fassarar, an yi izini kawai matakan bakwai na nesting.

A lokacin da aka kimanta ayyukan da aka haɓaka, Excel yakan fara aiki mafi zurfi ko aikin ciki ciki sannan yayi aiki ta waje.

Dangane da tsari na ayyuka biyu lokacin da aka hada,

Kodayake takaddun da ke cikin layuka shida zuwa takwas suna samar da sakamako mai kama da haka, tsari na ayyuka na iya zama mai mahimmanci.

Sakamakon dabarun a cikin layuka shida da bakwai sun bambanta da darajar ta kawai 0.01, wanda zai iya zama ko mahimmanci dangane da bukatun bayanai.

ROUND / SUM Formula misali

Matakan da ke ƙasa suna rufe yadda za a shigar da tsarin ROUND / SUM wanda yake cikin tantanin halitta B6 a cikin hoton da ke sama.

= ROUND (SUM (A2: A4), 2)

Ko da yake yana yiwuwa a shigar da cikakken tsari da hannu, mutane da yawa sun fi sauƙi don amfani da maganganun maganganu don shigar da tsari da kuma muhawarar.

Maganar maganganu ta sauƙaƙe shigar da muhawarar aiki a lokaci daya ba tare da damu da aikin haɗin gwiwar ba - irin su parenthesis kewaye da muhawarar da kalmomin da ke aiki a matsayin rabuwa tsakanin gardama.

Ko da yake aikin SUM yana da akwatin zane na kansa, ba za a iya amfani dashi lokacin da aka shigar da aikin a cikin wani aikin ba. Excel ba ya yarda a bude akwatin maganganu na biyu a yayin shigar da takamammen.

  1. Danna kan B6 ta jiki don sanya shi tantanin halitta.
  2. Danna kan Rubutun shafin shafin rubutun .
  3. Danna Math & Trig a cikin menu don buɗe jerin aikin sauke aikin.
  4. Danna ROUND a cikin jerin don buɗe akwatin maganganun ROUND.
  5. Danna maɓallin Lamba a cikin akwatin maganganu.
  6. Rubuta SUM (A2: A4) don shigar da SUM aiki a matsayin ƙidayar Magana na aikin ROUND.
  7. Danna maɓallin Lambobi a cikin akwatin maganganu.
  8. Rubuta 2 a cikin wannan layi domin ya zagaya amsa ga SUM aiki zuwa wurare biyu na decimal.
  9. Danna Ya yi don kammala tsarin da komawa zuwa aikin aiki.
  10. Amsar ta 764.87 ya kamata ya bayyana a cell B6 tun lokacin da muka ƙaddamar da adadin bayanai a cikin kwayoyin halitta D1 zuwa D3 (764.8653) zuwa wurare biyu na decimal.
  11. Danna kan salula C3 zai nuna aikin da aka yi
    = ROUND (SUM (A2: A4), 2) a cikin maɓallin tsari a sama da takardun aiki.

SUM / ROUND Array ko CSE Formula

Tsarin lissafi, irin su wanda yake a cikin sel B8, yana ba da izini don ƙididdiga masu yawa da zasu faru a cikin ɗayan ɗigon ɗawainiya ɗaya.

Wata takarda mai tsafta ta gane ta hanyar takalmin gyare-gyare ko ƙuƙwalwar ƙira {} da ke kewaye da tsari. Wadannan takalmin ba a buga su ba, duk da haka, amma ana shigar da su ta danna maɓallin Shift + Ctrl + Shigar da ke kan keyboard.

Saboda maɓallan da aka yi amfani da su don samar da su, tsararren tsararrakin wasu lokuta an kira su CSE.

Ana amfani da takaddun tsari don ba tare da taimakon akwatin maganganun ba. Don shigar da tsarin SUM / ROUND a cikin sakon B8:

  1. Danna kan b8 B8 don sa shi tantanin halitta mai aiki.
  2. Rubuta a cikin tsari = ROUND (SUM (A2: A4), 2).
  3. Latsa kuma ka riƙe maɓallin Shift + Ctrl a kan keyboard.
  4. Latsa kuma saki maɓallin shigarwa a kan keyboard.
  5. Darajar 764.86 ya kamata ya bayyana a tantanin halitta B8.
  6. Danna kan tantanin halitta B8 zai nuna nauyin mahaɗin
    {= ROUND (SUM (A2: A4), 2)} a cikin tsari.

Amfani da ROUNDUP ko ROUNDOWN A maimakon haka

Excel yana da wasu ayyuka masu tasowa guda biyu da suke da kama da aikin ROUND - ROUNDUP da ROUNDDOWN. Ana amfani da waɗannan ayyuka lokacin da kake son dabi'u su kasance a cikin wani takamaiman jagora, maimakon dogara ga dokokin fasalin Excel.

Tun da muhawarar waɗannan ayyuka guda ɗaya daidai da na aikin ROUND, ko dai za a sauya sauya cikin jigon da aka samo a sama a cikin shida.

Nau'in ROUNDUP / SUM tsarin zai zama:

= ROUNDUP (SUM (A2: A4), 2)

Nau'in tsarin ROUNDDOWN / SUM zai kasance:

= ROUNDOWN (SUM (A2: A4), 2)