Sir really , literally koi bhi video itne aache se explain nhi Kiya tha deep me par apneee kiya thank you aasse hi video bnate rhe or aassseee hi deeply pdatee rheeee thankkkklkkkk youuuuuu veryytyyy muchhhjjj
Sir, bahut achha laga.....lekin ek doubt...... RD Amount=1000 Rate of interest=8% Time=24 months Syntax of future value:- =FV(rate,nper,pmt,[pv],[type]) syntax ke hisab se values denge to =FV(8%/12,24,,1000,1) Ans=1172.89 aa raha hai pmt ko ignore karen to eisa ata hai But apka ans 26106.08 Sir how..............?
sir I have worksheet in this table i have created coloumn like maturity amount in numeric and date column i have applied conditional formatting, according to date colour should be changed to Red, yellow, green, now I want to know that according to due date column how-to apply conditional formatting so that in maturity amount coloumn colour also change to Red yellow green according to due date column colour? please make video on this asap thanks in advance for your help
सर! 2 साल, 11 महीने और 29 दिन के लिए quarterly compound interest on fd के लिए कौन सा फॉर्मूला एक्सेल में लगाएंगे? जबकि मेरे बैंक ने 407895 के ऊपर 6.5% व्याज की दर से 494856.10 मैच्योरिटी अमाउंट ऊपर दिए गए अवधि के लिए बनाया है। कृपया मार्गदर्शन करें🙏🙏🙏
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format. ruclips.net/video/lYiHbaFvR60/видео.html ruclips.net/video/6JLZ93I1LcE/видео.html
mujhe yeh bta dai k mujhe denomination banani hai Denomination values hai merai pass Like 1000*1=1000 500*1=500 100*9=900 50*2=100 Total =2500 Mane likha k 1500 k amount no of note Mai alag karai to wo Kasai hoga Guide karai please
Good evening sir Sir it's my humble request to you please help me sir Sir excel mein office work mein kya kya knowledge chahiye kya kya sikhna parega please help me sir
Office mein different jobs hoti hain ar usi k hisab se excel ko use kia jata hy yeh depend krta hy k ap ki job kia hy.suppose ap data entry operator ki job kr rahe hain, cashier ki job kr rahe hain,time keeper hain,clerk hn,administrator hain so ap koi b job kr rhe hun usi k hisab se he excel ka use kia jata hy.basic bat yeh hy k excel k jo basic function hain wo ap ko ana chayen us k bad yeh formolas ka usage atna mushkl ni hota
bro office work ke liye kam se kam excel ki basic knowledge hona jaruri hai jaise- data enter karna, us data ke liye sahi format banana, baisc formulon ka gyan hona, or print karna etc. uske baad ye ki aap kis office me kaam karte hain yani aapka kaam kya hai jaise aap accountant hain ya clerk hain. uske anusar excel ke alag alag field me alag alag kaam hain.
FV function doesn't give correct value if payment periods and compounding periods are different. Say, payments are made monthly but interest is compounded yearly or at tenure end.
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format. ruclips.net/video/lYiHbaFvR60/видео.html ruclips.net/video/6JLZ93I1LcE/видео.html
![Lil Uzi Vert - Chill Bae [Official Music Video]](http://i.ytimg.com/vi/D7F42F_JM3U/mqdefault.jpg)
I love you sir. Special love from Pakistan 🙂
All vidéo great sir n Thanku so much sir for this class sach me bhut hi achha samjh aata hai thanku sir
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Sir really , literally koi bhi video itne aache se explain nhi Kiya tha deep me par apneee kiya thank you aasse hi video bnate rhe or aassseee hi deeply pdatee rheeee thankkkklkkkk youuuuuu veryytyyy muchhhjjj
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Your videos are much informative .I learned lot of things from your videos .You are doing great job.
muhammad irfan from kashmir
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Sir aapki kirpa se mai free mai computer sikh rha hoon sir most thankful from heart.
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Very Good Sir
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
It's very helpful video sir
All video great sir
Keep watching
It makes sense to me to watch your two videos
Thank you sir
Avgraju
Nice Explaination keep it up
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Loan repayment farmula भी बताईये इसी प्रकार से
You learn IPMT,PPMT,PMT
Thanks sir very helpful video sir
All the best
Very good video sir
excellent sir
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Thank you sir😊👍🏻
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Nice video 👌👌👌
Great 🔥🔥
thank you sir ji 🎉
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Mind blowing sir
Thanks a lot
It is possible if interst is monthly compound for month wise future value calculation.
Sir, bahut achha laga.....lekin ek doubt......
RD Amount=1000
Rate of interest=8%
Time=24 months
Syntax of future value:-
=FV(rate,nper,pmt,[pv],[type])
syntax ke hisab se values denge to
=FV(8%/12,24,,1000,1)
Ans=1172.89 aa raha hai
pmt ko ignore karen to eisa ata hai
But apka ans 26106.08
Sir how..............?
Vo 1000rs. pv nahi pmt hai , sir se mistak ho gai hai 😂
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
Sir, class mgmt ke liye kuch bataiye excel pe
sir I have worksheet in this table i have created coloumn like maturity amount in numeric and date column i have applied conditional formatting, according to date colour should be changed to Red, yellow, green, now I want to know that according to due date column how-to apply conditional formatting so that in maturity amount coloumn colour also change to Red yellow green according to due date column colour? please make video on this asap thanks in advance for your help
excellent
Thanks!
सर! 2 साल, 11 महीने और 29 दिन के लिए quarterly compound interest on fd के लिए कौन सा फॉर्मूला एक्सेल में लगाएंगे? जबकि मेरे बैंक ने 407895 के ऊपर 6.5% व्याज की दर से 494856.10 मैच्योरिटी अमाउंट ऊपर दिए गए अवधि के लिए बनाया है। कृपया मार्गदर्शन करें🙏🙏🙏
Sir, apne formule mai pmt liya hai. aur pv ko chora hai
Nice sir
Actually there is some error here, we are using pmt(payment) instead of pv(present value) in this FV function
@@ShivGarg-dx2nq Yes bro I am confuse in Pmt & Pv .
Nice
Dear sir
Ex Beginner lesson 43 main Fv amount
why the brakets on the both sides in the whole Amount pl tell me sir
Avgraju
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format.
ruclips.net/video/lYiHbaFvR60/видео.html
ruclips.net/video/6JLZ93I1LcE/видео.html
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
in the FV formula you skipped FV and entered PMT. but said the reverse. Please correct.
Nic sir
mujhe yeh bta dai k mujhe denomination banani hai
Denomination values hai merai pass
Like
1000*1=1000
500*1=500
100*9=900
50*2=100
Total =2500
Mane likha k 1500 k amount no of note Mai alag karai to wo Kasai hoga
Guide karai please
sir ap pmt ki keemat derahy ho or keh rahy ho k pmt ko chr kr pv ki value deni ha
ky ap drust kr rahy hain
A.o.A
Why we divided rate of interest by 12
Good evening sir
Sir it's my humble request to you please help me sir
Sir excel mein office work mein kya kya knowledge chahiye kya kya sikhna parega please help me sir
Office mein different jobs hoti hain ar usi k hisab se excel ko use kia jata hy yeh depend krta hy k ap ki job kia hy.suppose ap data entry operator ki job kr rahe hain, cashier ki job kr rahe hain,time keeper hain,clerk hn,administrator hain so ap koi b job kr rhe hun usi k hisab se he excel ka use kia jata hy.basic bat yeh hy k excel k jo basic function hain wo ap ko ana chayen us k bad yeh formolas ka usage atna mushkl ni hota
bro office work ke liye kam se kam excel ki basic knowledge hona jaruri hai jaise- data enter karna, us data ke liye sahi format banana, baisc formulon ka gyan hona, or print karna etc. uske baad ye ki aap kis office me kaam karte hain yani aapka kaam kya hai jaise aap accountant hain ya clerk hain. uske anusar excel ke alag alag field me alag alag kaam hain.
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
FV function doesn't give correct value if payment periods and compounding periods are different. Say, payments are made monthly but interest is compounded yearly or at tenure end.
why my fv value is coming negative?
2:51
❤
at 7.14 minutes you said end of period then y u didnt select "0"
Sir mera intrat drag nhi aa rha 0 value aa rhi drag krne prr
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
Sir Both of your Answers are wrong. As your inputted your PV value in pmt value so you are getting wrong answers. Please check your video.
Sir 1000/- ka 8% 80 hoga to ye 6.67 kaise
@@moviehub8887 bhai yearly 80 rs ha... sir ne 80/12= 6.67 monthly calculate keaya ha... sir ne bola ha sunto lo
why the result came out in parentheses?
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format.
ruclips.net/video/lYiHbaFvR60/видео.html
ruclips.net/video/6JLZ93I1LcE/видео.html
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
Your second calculation is wrong, kindly recheck.
Eveline Falls
thora kathin hei
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a
vae.fyi
great
very detailed and informative video, thanks
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=dsP3xQvryzQWvEuQ
Nice sir
ruclips.net/video/7xhRJ7p1R_c/видео.htmlsi=AQDVzWMxIcBJ97-a