Made-in-Pakistan is one of the leading platforms for wholesale trade globally. We want to serve every buyer and supplier around every corner of the world.
Thanks. Very helpful tutorial. I used it for my google sheet for kids pocket money and monthly expenses and it worked great. Only issue I can't leave a cell blank and have to put zero if nothing else otherwise the formula breaks and starts again. But that's no big deal as there are just a few entries every month and I can easily add zeros manually to empty debit or credit fields.
Good Afternoon wonderful tutor, I appreciate all Indian tutors on youtube, they have helped me so far but please try to teach more in English. I can't understand your language but I need this lesson.
AoA. Sir ap ny F3 me cash balance likh k zhort key use ki jis sy cell bara ho gya and jb C4 me last year's balance likha os k bad phir apny wohi short key use ki. Kindly wo short key bta dy
@@shahabislam4912 no thanks you really deserve like and subscribe I also want to get some more lacture so I subscribe and click on bell icon for more videos
Hi Sir, you are simply fantastic. super explanation of debit credit. I watch your video most of the time and it is very very interesting and knowledgable. Thank you Sir God Bless you. As I practice my daughter really like it.
Assalam o alaikum sir mny same bnaya h jesy apny btya hua h but jb hm value ziada inter krty hn chahy debit me y credit me to wo ## ka sign dy deta h like 100000 ya 500000 add krty hn tb
mjhe confusion ha k ap ny cash balance ma formula lgaty hue debit or credit ko uper nechy select kiu kia koi uper ka or koi nechy ka select kr k formula lgaya? kiu?
Many many thanks for your prompt reply. Please tell me what the formula will be if I connect the 'credit' (E5) instead of the 'description' (C4) and get serial numbers as and when only a credit entry is entered? I want to know how many EMIs I have paid by seeing only the last serial number against the last credit entry.
Jazakallah brother this was perfect and just what I was looking. The formulas are simple and clearly explained, and in Urdu loved it. May Allah swt bless you and your family and fill your life with barakat and His mercy. You my brother have a subscriber... great job
SIR PLZZ MERI PROBLEM SOLVED KEJIYE JESE IDBI BANK KI STATMENT MAI DR AMONUT OR CR AMOUNT AK HE COLOUM MAI HOTI HAI AGAR HAME DR KA COLOUM ALAG OR CR KA COLOUM ALAG RAKHNA HO TO KESE HOGA PLZZZ VIDEO BANAO ESPE SIR
As salam o aalaikum bhai ma ne ye formula apply kia start ki entries ma work kar raha hai us k bad #VALUE! show ho raha hai, kindly help aisa ku ho raha hai.
bhai mre excell me formula lag to rha h lkn jb new valu dal rhe hn to formula automatically abdate nh kar raha us ko click kr k enter karna parh rha h phr wo abdate kar rha h ap plz mri help kar dn
assalamu alaikum bhai mujhe bhi ek excel sheet banani hai mere pass ek image hai wo main aapko send karta hu uss type ka muhe banana hai kya aap meri help kar sakte hai. wo sheet jo banani hai wo masjid ki hai.
![[LIVE] นาทีนี้ต้องพี่ทนาย | ทนายแก้ว vs ทนายไพศาล | #คุยให้เด็กมันฟัง EP.47 (02/11/67)](http://i.ytimg.com/vi/HmquaO-PL_M/mqdefault.jpg)
Superb Sir . . . . Thank you so much Allah Apko Hamesha Abaad Rakhay Ameen ♥
Thanks for information I have e totally kharch in office I have saved in my devise Thanks a lot🙏
it's very helpful video sir
Keep watching
Assalam o Alaikum sir..ye Jo ap short cut keys use krte Hain inko bhi mention Kiya kren
Made-in-Pakistan is one of the leading platforms for wholesale trade globally. We want to serve every buyer and supplier around every corner of the world.
Thanks. Very helpful tutorial. I used it for my google sheet for kids pocket money and monthly expenses and it worked great. Only issue I can't leave a cell blank and have to put zero if nothing else otherwise the formula breaks and starts again. But that's no big deal as there are just a few entries every month and I can easily add zeros manually to empty debit or credit fields.
Fantastic tutorial. Where can i download this excel sheet. Cant find it
Sir debit ko minus and credit ko add nahi krna tha?
thats what im talking about, but
Jazakumullahu khairan
Sir ye tho simple hai, surf +, - ho Raha hai interest iss Mai add hoga 😇
Very helpful , Thanks
You're welcome!
Hello Sir good tutorial but I am confused!!! In accounting EXPENSE ACCOUNT IS DEBIT BALANCE RIGHT?? Your example is CREDIT. Why???
Very nice explanation of this formulas but only one mistake debit side minus Hoga & credit side plus hoga
Sir. Account se related bi video upload kr do jese tally erp 9 and Busy accountancy etc
TQ SIRR. REALLY HELPS ME A LOT.
You are most welcome
Arre wah! kitna simple. Thank you bro. 🙏
Most welcome 😊
Excellent tutorial.
Many thanks!
good video sir
Thanks
Bhai thank you 🤗
Good Afternoon wonderful tutor, I appreciate all Indian tutors on youtube, they have helped me so far but please try to teach more in English. I can't understand your language but I need this lesson.
Good one
Thanks very helpful
So divide by month with interest
AoA.
Sir ap ny F3 me cash balance likh k zhort key use ki jis sy cell bara ho gya and jb C4 me last year's balance likha os k bad phir apny wohi short key use ki.
Kindly wo short key bta dy
IT WAS REALLY GREAT. THANK YOU FOR THE EFFORTS YOU PUT INTO CREATING THIS VIDEO
Glad you liked it!
जय श्री राम 🙏🚩🕉️
so nice of you
Good job Sir, but SoooO Confusion and difficult proccedur ledger
Agr credit ky ya debit ky 2 cells rkhny hoon
Sir, it's too much good but I've a question, when I put my credit balance it is shows in subtract sign in cash balance
very Good. Thaks
Thank you for giving me an idea.
Most welcome 😊
Sir date k uper formula lag sakta h kya
THANKS ALOT SIR. GOOD TUTORIAL
You are most welcome
LOVE FROM bANGLADESH🤩🤩🤩🤩🤩🤩🤩
You are posting entries just how we post entries in ledger? Not in journal?
Thanks
Thnaks
I love ur voice so much....u r real gem....
Thank you!
You're welcome!
Brilliant bro.. Thank you so much...
Most welcome 😊
Great sir
Explain why if and function are used here when only sum formulas can be used?
Agr hmary pas last year ka balance na ho to kia kren
Very helpful tutorial. I want to get this software.
Very nice video
Thanks
@@shahabislam4912 no thanks you really deserve like and subscribe
I also want to get some more lacture so I subscribe and click on bell icon for more videos
@@shahabislam4912 and i also see more videos in your channel about Excell and Word
Hi Sir, you are simply fantastic. super explanation of debit credit. I watch your video most of the time and it is very very interesting and knowledgable. Thank you Sir God Bless you. As I practice my daughter really like it.
All the best
don't west your time , Start watching 7:38 Sec
Hi sir ye formula ek hi lejar me 2 bar kam kio nhi krrha h =IF(AND bala batana sir
Assalam o alaikum sir mny same bnaya h jesy apny btya hua h but jb hm value ziada inter krty hn chahy debit me y credit me to wo ## ka sign dy deta h like 100000 ya 500000 add krty hn tb
ap column width bri karen. us column k top me jakar jahan abc k nam are hote hen column waha line per double click karen.
@@shahabislam4912 thanks boss it's working...
thank you so much bahut help hui
Very very good Sir Thenks
Thank u so much sir
THANKS DEAR IT WAS VERY USE FULL
Welcome 😊
Excellent
Debit and credit
Good
mjhe confusion ha k ap ny cash balance ma formula lgaty hue debit or credit ko uper nechy select kiu kia koi uper ka or koi nechy ka select kr k formula lgaya? kiu?
i put this formula in sheet but showing false in balance column....please tell what is my mistake
Tq
Thank you sir!!
Nice
Many many thanks for your prompt reply. Please tell me what the formula will be if I connect the 'credit' (E5) instead of the 'description' (C4) and get serial numbers as and when only a credit entry is entered? I want to know how many EMIs I have paid by seeing only the last serial number against the last credit entry.
Masha Allah. Sir agar opening balance minus (-) me ho ky Kya karen sir plz reply
Same doubt mera v
Thanks for this video😎
Welcome 😊
Mofiz bhai ke awaaz hai
Sir how to write 100,000.00 in excel.....by formula its putting one extra comma after 1 for eg its showing it as 1,00,000.00
Your r doing very professionally but its lil bit complicated
Need Complete Cargo Inventory Management Sheet.
sir same processes krne pr bhi false aa rha h
Thank you man great job ❤
Thank you too
Excellent!
Jazakallah brother this was perfect and just what I was looking. The formulas are simple and clearly explained, and in Urdu loved it. May Allah swt bless you and your family and fill your life with barakat and His mercy. You my brother have a subscriber... great job
Purchase of Chair ko Cr Q kiya hai? Purchase to expense hai Dr hona Chahiye.
Please add thees formulas in description so that we can copy and past
Thankyou bhai
Super
Please tell formula of balance sheet
Me debit credit k item ko barana chahta hoo lekin neeche wali row khud neeche jaati rahe.. matlab final total wali row fixed rehni chahye.
THANKS BRO
Welcome
SIR PLZZ MERI PROBLEM SOLVED KEJIYE
JESE IDBI BANK KI STATMENT MAI DR AMONUT OR CR AMOUNT AK HE COLOUM MAI HOTI HAI
AGAR HAME DR KA COLOUM ALAG OR CR KA COLOUM ALAG RAKHNA HO TO KESE HOGA PLZZZ VIDEO BANAO ESPE SIR
th-cam.com/video/tP5qRJ76Ugw/w-d-xo.html
As salam o aalaikum
bhai ma ne ye formula apply kia start ki entries ma work kar raha hai us k bad #VALUE! show ho raha hai, kindly help aisa ku ho raha hai.
Your Greet
This video is fully helpful for me thank you 🙏
You're welcome 😊
Good morning # value aata hai time in or time out ko jab select mana jise ki =(D5-E5)+(G5-F5) formula
or mre axcell me formula copy to ho rha h lkn value ek hi arhi js cell me formula put kia ho uski chnge nh arhi copy past per
Very supper way of explanation. Masha Allah. May I request you to please explain the excel functions and formulas using in Finance Organization.
th-cam.com/channels/cOsbNCxgUZMPoHEI1w-1RA.htmlsearch?query=finance
Wonderful
Sbi account mai mistake se kisine 1000 bhejatha phir auto debit ho geya kesse
Well done Sir.
bhai mre excell me formula lag to rha h lkn jb new valu dal rhe hn to formula automatically abdate nh kar raha us ko click kr k enter karna parh rha h phr wo abdate kar rha h ap plz mri help kar dn
formula menu me calculation option last me he usme automatic click karen
Sir ager hme ye check Krna h ki credit kitni Baar hua count mein tb hum kaise krenge
Count Formula se
Wrong formula debit aur credit ka matlab ulta kar diye he apne
thanks but please tell me what if there in no debit and credit entry in specific date then this formula not working.pls help.
assalamu alaikum bhai mujhe bhi ek excel sheet banani hai mere pass ek image hai wo main aapko send karta hu uss type ka muhe banana hai kya aap meri help kar sakte hai. wo sheet jo banani hai wo masjid ki hai.
kya aap apna contact details de sakte hai
facebook.com/shahabislam123
Marvelllous
Destination and tonnage wise automatically freight rate list me pick ho jaye aisa formulation bata dijiye , shukriya
Sir How To Remove - minus sign After this formula is given ?
abs formula
balance sheet me drag krte hi wo to age tak ka record de rha he
time sheet
👍👍
❤