Kuphatikiza zochitika za ntchito ziwiri kapena zambiri - monga ROUND ndi SUM - mwa njira imodzi mu Excel nthawi zambiri imatchedwa ntchito zachisa .
Kudyetsa kumaphatikizapo pokhala ndi ntchito imodzi yogwirizana ndi ntchito yachiwiri.
Mu chithunzi pamwambapa:
- Chitsanzo cha mzere wachisanu ndi chimodzi chiri ndi ntchito ya SUM yokhala ngati ndondomeko ya chiwerengero cha ntchito ya ROUND.
- Mzere wachisanu ndi chiwiri uli ndi ROUND yambiri ikugwira ntchito monga ziwerengero za ntchito ya SUM.
Kuphatikiza Ntchito ROUND ndi SUM mu Excel
Kuchokera ku Excel 2007, chiwerengero cha ntchito zomwe zingakhale zogona pakati pa wina ndi mzake ndi 64.
Zisanayambe, izi zokha zisanu ndi ziwiri zokha zimaloledwa.
Pofufuza ntchito zokhumba, Excel nthawizonse imapanga ntchito zakuya kapena zakuya poyamba ndikuyendetsa panja.
Malingana ndi dongosolo la ntchito ziwirizo pokhudzana,
- Mizere kapena zigawo za deta zingathe kufotokozedwa ndikutsatiridwa ku chiwerengero cha malo osungiramo zonse mkati mwa selo limodzi lamasamba, mzere wachisanu ndi umodzi pamwambapa.
- Makhalidwe angayambe kutsindikizidwa ndikukambitsirana, mzere wachisanu ndi chiwiri pamwambapa.
- Makhalidwe angayambe kukambidwa ndikukambitsirana, zonse mu selo limodzi pogwiritsa ntchito njira yachitsulo ya SUM / ROUND, mzere wachisanu ndi chitatu pamwambapa.
Ngakhale kuti mizere 6 mpaka 8 imapanga zotsatira zofananako, dongosolo la ntchito zachisazi zingakhale zofunikira.
Zotsatira za malemba m'magawo asanu ndi limodzi ndi asanu ndi awiri zimasiyana kwambiri ndi 0.01, zomwe zingakhale zosafunikira malinga ndi zofunikira za data.
ROUND / SUM Mphindi chitsanzo
Masitepe omwe ali m'munsimu akuthandizani momwe mungalowerere fomu ya ROUND / SUM yomwe ili mu selo B6 mu chithunzi pamwambapa.
= ROUND (SUM (A2: A4), 2)
Ngakhale kuti n'zotheka kulowa ndondomeko yanunthu, anthu ambiri amavutika kuti agwiritse ntchito bokosi la zokambirana kuti alowe muyeso ndi zotsutsana.
Bukhuli likuphweka kulowera zomwe zimagwira ntchito pa nthawi imodzi popanda kusadandaula za chigwirizano cha ntchito - monga mafotokozedwe ozungulira zotsutsana ndi makasitomala omwe amachititsa kukhala olekanitsa pakati pa zotsutsana.
Ngakhale ntchito ya SUM ili ndi malingaliro ake, sungagwiritsidwe ntchito pamene ntchitoyi ili mkati mwa ntchito ina. Excel samalola yachiwiri kukambirana bokosi kuti atsegule pamene akulowa fomu.
- Dinani pa selo B6 kuti mupange selo yogwira ntchito.
- Dinani pa Fomu tab ya riboni .
- Dinani pa Math & Trig mu menyu kuti mutsegule ntchito yolemba pansi.
- Dinani pa ROUND mumndandanda kuti mutsegule bokosi la ntchito la ROUND.
- Dinani pa Nambala mzere mu bokosi la bokosi.
- Lembani SUM (A2: A4) kuti mulowetse ntchito ya SUM monga nambala yotsatira ya ntchito ya ROUND.
- Dinani pa Num_digits mzere mu bokosi la dialog.
- Lembani 2 mu mzerewu kuti muyankhe yankho ku ntchito ya SUM ku malo awiri osachepera.
- Dinani OK kuti mutsirizitse ndondomekoyi ndi kubwerera kuntchito.
- Yankho la 764.87 liyenera kuoneka mu selo B6 popeza tathetsa chiwerengero cha deta m'maselo D1 mpaka D3 (764.8653) mpaka malo awiri.
- Kusindikiza pa selo C3 kudzawonetsa ntchito yachisa
= ROUND (SUM (A2: A4), 2) mu barolo lazenera pamwamba pa tsamba.
SUM / ROUND Mzere kapena CSE Makhalidwe
Njira yothandizira, monga yomwe ili mu selo B8, imalola kuti mawerengedwe angapo azichitika mu selo limodzi lamasewera.
Ndondomeko yambiri imadziwika bwino ndi mabotolo ozungulira kapena ophimbirako {} omwe akuzungulira njirayi. Izi zimapangidwira, koma zimalowa mwa kukakamiza makiyi a Shift + Ctrl + Enter pa makiyi.
Chifukwa cha mafungulo omwe amagwiritsidwa ntchito kuti apange, malemba ena nthawi zina amawatcha machitidwe a CSE.
Zowonongeka zimalowa mkati popanda thandizo lazokambirana. Kulowa ndondomeko ya SUM / ROUND mu selo B8:
- Dinani pa selo B8 kuti mupange selo yogwira ntchito.
- Lembani muyeso = ROUND (SUM (A2: A4), 2).
- Onetsetsani ndipo gwiritsani makiyi a Shift + Ctrl pa makiyi.
- Sakanizani ndi kumasula fungulo lolowamo pa kibokosi.
- Phindu la 764.86 liyenera kuoneka mu selo B8.
- Kusindikiza pa selo B8 kudzawonetsera ndondomeko yambiri
{= ROUND (SUM (A2: A4), 2)} mu bar.
Mukugwiritsa ntchito ROUNDUP kapena ROUNDDOWN M'malo mwake
Excel ili ndi ntchito ziwiri zozungulira zomwe ziri zofanana ndi ntchito ROUND - ROUNDUP ndi ROUNDDOWN. Ntchitozi zimagwiritsidwa ntchito pamene mukufuna kuti miyezo ikhale yozungulira, osati kudalira malamulo a Excel.
Popeza kuti zifukwa zonsezi ndi zofanana ndi za ntchito ya ROUND, mwina zingalowe m'malo mwazomwe zili pamwambazi mu mzere wachisanu ndi umodzi.
Maonekedwe a ROUNDUP / SUM chikhalidwe adzakhala:
= ROUNDUP (SUM (A2: A4), 2)
Maonekedwe a ROUNDDOWN / SUM formula adzakhala:
= ROUNDDOWN (SUM (A2: A4), 2)