Xisaabinta cadadka xaashida xaashida waa mid ka mid ah sababaha aasaasiga ah ee loo isticmaalo barnaamijka xisaabaadka sida Excel ama bogga internetka sida Google Sheets . Waa faa'iido leh marka la macaamilayo xog badan, ootamaatig ah dabagalka kharashka^{(automating expense tracking)} , iyo in ka badan.

Qaaciddada si toos ah ugu darsata unugyada ayaa aad uga fudud in la soo saaro xisaabiyaha si uu gacanta ugu sameeyo xisaabta. Si la mid ah xisaabaadka kale ee xisaabta. Waxa kaliya ee aad u baahan tahay waa qiyamka aad ku shaqayn doonto, hababka aynu hoos ku eegi doono waxay kuu samayn doonaan dhammaan culaysyada culus.

Inta badan softiweerka xaashida ayaa si isku mid ah u shaqeeya marka ay timaado ku darida, kala-goynta, dhufashada, iyo qaybinta, markaa tillaabooyinkani waa in ay shaqeeyaan iyada oo aan loo eegin waxa qalabka xaashida ee aad isticmaalayso.

Si toos ah ugu dar oo kala jar xaashida faafinta^{(Automatically Add & Subtract In a Spreadsheet)}

Tixgeli xaashida xisaabaadka fudud ee haya kharashyada, dhigaalka, iyo hadhaaga hadda. Waxaad ku bilaabaysaa baaqi muujinaya inta lacag ah ee aad haysato, waxayna u baahan tahay in kharashaadka laga gooyo oo dhigaal lagu daro si ay u joogto. Foomamka waxaa loo isticmaalaa in si fudud loo xisaabiyo dheelitirka.

Halkan waxaa ah tusaale fudud oo ah sida kharash badan looga jari karo hadhaaga:

Waxaan rabnaa hadhaaga hadda inuu ka hoos muujiyo midka jira ee $10,000. Si taas loo sameeyo, waxaanu dooranay unugga meesha aanu rabno in xisaabtu ka muuqato, ka dibna ku dheji = calaamad ay ku xigto xisaabinta. 

Calaamadda = had iyo jeer waa lagama maarmaan si loo bilaabo qaacido kasta oo xaashida faafin ah. Inta soo hartay waa mid toos ah: Qaado hadhaaga hadda (C2) oo laga jaray kharashka (A3), sida adiga oo kale haddii aad ka jarayso qiyamkan warqad. Riixitaanka Gelida^(Enter) marka lagu dhammeeyo qaacidada waxay si toos ah u xisaabinaysaa qiimaha $9,484.20.

Sidoo kale, haddii aan rabno inaan ku darno deebaaji dheelitirka, waxaan dooran doonnaa unugga aan rabno in xogta lagu soo bandhigo, ku dheji = saxiix, ka dibna ku sii wad xisaab fudud wixii aan u baahan nahay: C3+B4 . 

Waxa aan sameynay ilaa hadda waa in aan tusno sida loo sameeyo isku-darka iyo kala-goynta fudud ee xaashida, laakiin waxaa jira qaabab horumarsan oo aan adeegsan karno kuwaas oo xisaabinaya natiijooyinkan isla markaaba aad gasho kharashka ama dhigaalka. Isticmaalkooda ayaa kuu ogolaan doona inaad geliso lambarada tiirarkaas si hadhaaga u dambeeya uu si toos ah u soo baxo.

Si tan loo sameeyo, waxaan u baahanahay inaan abuurno haddii / ka dib qaacidooyinka. Waxay noqon kartaa wax yar oo jahawareer ah haddii tani ay tahay markii ugu horeysay ee aad eegto caanaha dheer, laakiin waxaan u kala qaybin doonaa qaybo yaryar si aan u aragno waxa ay dhammaantood ka dhigan yihiin.

=ifs(A5>0,C4-A5,B5>0,C4+B5,TRUE,””)

Qaybta ifs - ku waxay si fudud u odhanaysaa waxaan rabnaa in aan ku dhigno wax ka badan hal "haddii" sababtoo ah ma garanayno haddii kharashka ama deebaajiga la buuxin doono. Waxaan rabnaa in hal qaacido uu shaqeeyo haddii qarashka la buuxiyo (tani waxay noqon doontaa kala goyn sida kor ku cad) iyo mid kale (ku dar) haddii deebaajiga la galo.

• A5>0 : Tani waa kan ugu horreeya haddii bayaan sheegaya haddii A5 uu ka weyn yahay 0 (ie, haddii ay jirto qiimo halkaas oo dhan ah), ka dibna samee kuwan soo socda ...
• C4-A5 : Tani waa waxa dhacaya haddii ay jirto qiimo A5; waxaanu qaadan doonaa hadhaaga marka laga reebo qiimaha A5.
• B5>0 : Tani waa bayaanka 'if' ee kale ee weydiinaya in goobta dhigaalka la buuxiyay iyo in kale.
• C4+B5 : Haddii ay jirto deebaaji, dabadeed ku dar baaqiga si aad u xisaabiso hadhaaga cusub.
• RUN,””^{(TRUE,””)} : Kani waa meel-haye ku calaamadin doonta unugga waxba ilaa ay jiraan wax la xisaabiyo mooyee. Haddii aad tan ka tagto, markaa unug kasta oo isticmaala formula laakiin aan haysan wax lagu xisaabiyo, wuxuu muujinayaa #N/A , oo aan u muuqan mid aad u fiican.

Hadda oo aanu hayno qaacido si toos ah u xisaabin doona cadadkan, waxaanu ku jiidi karnaa qaacidada hoos xaashida xisaabaadka si aanu ugu diyaargarowno gelis kasta oo aanu ku samaynayno kharshka ama tiirka dhigaalka.

Markaad buuxiso qiimayaashan, tiirka hadhaaga ayaa isla markiiba xisaabin doona lacagta.

Barnaamijyada faafinta waxay la macaamili karaan in ka badan laba unug hal mar, markaa haddii aad u baahan tahay inaad ku darto ama ka jarto unugyo badan isku mar, waxaa jira dhowr siyaabood oo loo sameeyo:

• =ADD(B2,B30)
• =MINUS(F18,F19)
• =C2+C3+C4+C5
• =A16-B15-A20

Sida Loo Qaybsado, Loo dhufto, & Wax Ka Badan^{(How To Divide, Multiply, & More)}

Qaybinta iyo dhufashada ayaa la mid ah sida wax-ku-darka iyo kala-goynta. Isticmaal * si aad u dhufato iyo / u qaybiso. Si kastaba ha ahaatee, waxa ku yara jahawareerin kara marka aad u baahan tahay inaad ku biirto dhammaan xisaabaadkan kala duwan ee hal unug.

Tusaale ahaan, marka qaybinta iyo isku-darka la wada isticmaalo, waxa loo qaabayn karaa sida =sum(B8:B9)/60 . Tani waxay qaadanaysaa wadarta B8 iyo B9 ka dibna waxay qaadanaysaa jawaabtaas oo^(that) loo qaybiyay 60. Mar haddii aan u baahanahay isku darka in marka hore la sameeyo, waxaan marka hore ku qornaa qaacidada.

Waa tan tusaale kale, marka isku dhufashada oo dhan ay buul ku samaysmaan qaybo iyaga u gaar ah si ay u wada dhammeeyaan, dabadeedna shakhsiyaadkaas jawaabaha la isugu geeyo: =(J5*31)+(J6*30)+(J7*50) .

Tusaalahan, =40-(sum(J3:P3)) , waxaanu go'aaminaynaa inta saacadood ee ka hadhay 40 marka wadarta J3 ilaa P3 la xisaabiyo. Mar haddii aynu ka jarayno wadarta 40, waxa aynu marka hore gelinaa 40 sida mushkiladda xisaabta caadiga ah, ka dibna waxa aynu ka jaraynaa wadarta guud.

Markaad xisaabinayso buul, xasuuso siday u kala horreeyaan hawlaha si aad u ogaato sida wax walba loo xisaabin doono:

• Xisaabinta waalidka ayaa marka hore la sameeyaa.
• Jibbaarada ayaa ku xiga.
• Kadib isku dhufashada iyo qaybinta.
• Isku-darka iyo kala-goynta ayaa u dambeeya.

Waa kuwan tusaale ku saabsan sida saxda ah iyo sida aan habboonayn ee habka hawlgallada ee dhibaatada xisaabta fudud:

30 waxaa loo qaybiyay 5 jeer 3^{(30 divided by 5 times 3)}

Habka saxda ah ee tan loo xisaabiyo waa in la qaato 30/5 (taas oo ah 6) oo lagu dhufto 3 (si loo helo 18). Haddii aad ka baxdo nidaamka oo aad qaadato 5*3 marka hore (si aad u hesho 15) kadibna aad qaadato 30/15, waxaad helaysaa jawaabta khaldan ee 2.

How To Format Spreadsheet Cells To Automatically Calculate Amounts

Cаlculating amounts in a spreadsheet iѕ one of the most basic reasons to υse a spreadsheet program like Excel or a spreadsheet website like Gоogle Ѕheets. It’s useful when dealing with largе sets of data, automating expense tracking, and more.

A formula that automatically adds cells is much easier than pulling out a calculator to do the math manually. The same is true for other math calculations. All you need are the values that you’ll be working with, and the formulas we’ll look at below will do all the heavy lifting for you.

Most spreadsheet software work the exact same when it comes to adding, subtracting, multiplying, and dividing, so these steps should work no matter what spreadsheet tool you’re using.

Automatically Add & Subtract In a Spreadsheet

Consider a simple spreadsheet that holds expenses, deposits, and the current balance. You start with a balance that shows how much money you have available, and it needs to have expenses subtracted and deposits added to stay current. Formulas are used to easily calculate the balance.

Here’s a simple example of how to subtract a large expense from a balance:

We’re wanting the current balance to show up below the existing one of $10,000. To do that, we’ve selected the cell where we want the calculation to show up in, and then put an = sign followed by the calculation. 

The = sign is always necessary to start off any formula in a spreadsheet. The rest is pretty straightforward: Take the current balance (C2) minus the expense (A3), just like you would if you were subtracting these values on paper. Pressing Enter when finished with the formula automatically calculates the value of $9,484.20.

Similarly, if we wanted to add a deposit to the balance, we’d select the cell we want the data to show up in, put an = sign in it, and then continue with simple math for what we need added: C3+B4. 

What we’ve done so far is show how to do simple adding and subtracting in a spreadsheet, but there are some advanced formulas we could use that calculate these results right after you enter the expense or deposit. Using them will let you enter numbers into those columns to have the final balance show up automatically.

To do this, we need to create if/then formulas. It can be a little confusing if this is your first time looking at a long formula, but we’ll break it all down into small chunks to see what they all mean.

=ifs(A5>0,C4-A5,B5>0,C4+B5,TRUE,””)

The ifs part is simply saying that we’re wanting to match more than one “if” because we don’t know if the expense or the deposit will be filled out. We want one formula to run if the expense is filled out (this would be subtraction like shown above) and a different one (addition) if the deposit if entered.

• A5>0: This is the first if statement that says if A5 is greater than 0 (i.e., if there’s a value there at all), then do the following…
• C4-A5: This is what happens if there’s a value in A5; we’ll take the balance minus the value in A5.
• B5>0: This is the other ‘if’ statement that asks whether the deposit field is filled out.
• C4+B5: If there’s a deposit, then add it to the balance to calculate the new balance.
• TRUE,””: This is a placeholder that will mark the cell with nothing unless there’s something to calculate. If you omit this, then every cell that uses the formula but doesn’t have something to calculate, will show #N/A, which doesn’t look very nice.

Now that we have a formula that will automatically calculate these amounts, we can drag the formula down the spreadsheet to prepare for any entries we make in the expense or deposit column.

As you fill out these values, the balance column will calculate the amounts immediately.

Spreadsheet programs can deal with more than two cells at once, so if you need to add or subtract multiple cells simultaneously, there are a couple ways to do it:

• =ADD(B2,B30)
• =MINUS(F18,F19)
• =C2+C3+C4+C5
• =A16-B15-A20

How To Divide, Multiply, & More

Dividing and multiplying is just as easy as adding and subtracting. Use * to multiply and / to divide. However, what can get a little confusing is when you need to merge all these different calculations into one cell.

For example, when division and addition is used together, it might be formatted as =sum(B8:B9)/60. This takes the sum of B8 and B9 and then takes that answer divided by 60. Since we need the addition to be performed first, we write it first in the formula.

Here’s another example, where all the multiplication is nested in their own sections so that they’re done together, and then those individuals answers are added together: =(J5*31)+(J6*30)+(J7*50).

In this example, =40-(sum(J3:P3)), we’re determining how many hours are left out of 40 when the sum of J3 through P3 is calculated. Since we’re subtracting the sum from 40, we put 40 first like a regular math problem, and then subtract from it the total sum.

When nesting calculations, remember the order of operations to know how everything will be calculated:

• Parentheses calculations are performed first.
• Exponents are next.
• Then multiplication and division.
• Adding and subtracting are last.

Here’s an example of the proper and improper use of the order of operations in a simple math problem:

30 divided by 5 times 3

The correct way to calculate this is by taking 30/5 (which is 6) and multiplying it by 3 (to get 18). If you go out of order and take 5*3 first (to get 15) and then take 30/15, you get the wrong answer of 2.

Related posts

• Sida loo qaabeeyo qoraalka Discord: Font, Bold, Italicize, Strithrough, iyo in ka badan

• 7-da Hab ee ugu Wanaagsan ee loogu Beddelayo PDF File Format Word

• Waa maxay Qaabka Faylka ugu Wanaagsan ee Wadayaasha USB?

• Sida Si Toos ah Looga Saaro Kombayutarkaga Software-ka Aan La rabin

• Sida loo qaabeeyo USB Drive iyo Memory Stick oo leh NTFS

• Waa maxay Qaabka WebP-ga iyo sida looga fogaado

• Sida looga takhaluso raadinta Yahoo gudaha Chrome

• Waa maxay macnaha BCC iyo CC? Fahamka Emailka aasaasiga ah ee Lingo

• Sida loo qaabeeyo Hard Drive-ka Dibadda ee FAT32 gudaha Windows

• Sida Looga Joojiyo Internet Explorer & Edge Si Toos Ah U Furan

• Sida Loo Sameeyo Printer Kasta Wireless Wireless 6 Siyaabo Oo Kala Duwan

• Sida loo ogaado Computer & Email Monitoring ama Basaas Software

• Sida Loo Helo Maalmaha Dhalashada Facebook-ga

• Sida Luqadda loogu beddelo Netflix

• 4 Siyaabaha Lagu Helo Xulashada Internetka ee Ugu Wanaagsan (ISPs) ee aaggaaga

• Sida loogu shubo Roku TV ka PC ama Mobile

• Sida Looga Qaado Sawir-qaadista Steam

• Sida otomaatig ah loogu cusboonaysiiyo darawalada aaladaha gudaha Windows 10

• Sida loo soo dejiyo oo loogu rakibo Peacock on Firestick

• Sida loo Geliyo Emoji gudaha Word, Google Docs iyo Outlook