Microsoft EXcel Advance formulate


Loan database Formulae

Total Interest = Loan amount X interest percent
Installment = Loan period X 12
Monthly Amount =  Loan amount / Installment
Monthly Interest = Total Interest / Installment
Monthly Payment = Monthly Amount + Monthly Interest
Total Pay = Monthly Pay X Installment 




Depreciation for Formulae
There are Two types of Depreciatio calculation Method :
First Method : SLM ( Straight Line Method ) 
Second Method : WDV ( Written Down Value ) 

 Formulae For SLN =sln(cost,salvage,value) Enter
First year Book Value = cost-first year depreciation
Second Year Book Value = First Year Dep. - Second Year Dep.
Now Increment ++

 Formulae For WDV
=db(cost,salvage,period,year) Enter
First year Book Value = cost-first year depreciation
Second Year Book Value = First Year Dep. - Second Year Dep.
Now Increment ++

Cash Reciept Formulae 
particular =vlookup(product id मा click , रेन्ज select गर्ने , 2,0) Enter
Rate = vlookup(product id click , Range select , 3,0) Enter
Amount= rate X quantity
Total =Sum(जोडनुपर्ने नम्बरहरु सबैलाई सेलेक्ट गर्ने ) enter
Discount Amount = Total X Discount percentage / 100
Amount with discount = Total - Discount Amount
Tax amount = Amount with Discount X Tax percentage / 100
Amount with Tax = Amount with Discount + Tax Amount
Total Amount  =  Amount with Tax +0

Picture Vlookup 
=index (सबै फोटो सेलेक्ट गर्ने , match( Lookupvalue यानकी छेउको Employee id मा क्लिक गर्ने,Data मा भयको सबै Employee id सेलेक्ट गर्ने , 0))



Comments

Post a Comment

Popular posts from this blog

Nepali story privacy policy

Privacy Policy Dipesh Rai built the Nepali Story app as a Free app. This SERVICE is provided by Dipesh Rai at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Nepali Story unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information, including but not limited to xyz....
Read more

privacy policy for tomb runner

Privacy Policy Dipesh Rai built the Tomb Rider app as a Free app. This SERVICE is provided by Dipesh Rai at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Tomb Rider unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information, including but not limited to xyz. The...
Read more

Microsoft Access practice note

Microsoft Access  is a  database management system  (DBMS) from  Microsoft  that combines the  relational   Microsoft Jet Database Engine  with a  graphical user interface  and software-development tools. It is a member of the  Microsoft Office  suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to  data  stored in other applications and databases. [3] Software developers ,  data architects  and  power users  can use Microsoft Access to develop  application software . Like other Microsoft Office applications, Access is supported by  Visual Basic for Applications  (VBA), an  object-based  programming language that can reference a variety of objects including the legacy DAO (Data Access Objects),  Active...
Read more