How to Calculate EMI in Excel Create EMI Calculator | EMI Calculation in Excel with Option Button

Today we will talk about emi calculation - excel formula & expert emi calculator [hindi]. Excel gives you PMT formula which helps us to calculate emi in excel. But here we will using formula for calculating emi in excel , calculate EMI with option button.

Steps to do :-

1) Convert rate of interest and year in months.

2) Put 4 option button in excel, so that user get facility to select anyone among them.

3) Write PMT formula to calculate emi in excel.

4) Also use IF formula for different result as per the selection of option button.

Please click on the below link to watch out different playlist :-

1) Microsoft Excel Formula in Hindi : shorturl.at/cdmM7
2) Power BI Tutorial for Beginners in Hindi : shorturl.at/cmJT4
3) SQL Tutorial for Beginners in Hindi : shorturl.at/dptvQ
4) Visual Basic (VBA) Tutorial for Beginners in Hindi : shorturl.at/eioD2
5) Vlookup Formula Series in Hindi : shorturl.at/dpzX3
6) Computer Technology : Tutorial for Beginners in Hindi : shorturl.at/fGPRV
7) MIS Interview Questions : shorturl.at/txIX6

Tags : how to calculate emi in excel | emi calculation in excel in hindi | calculate emi with option button | calculate emi in excel | how to calculate loan emi | calculation of emi in excel | formula for calculating emi in excel | calculation of loan emi in excel sheet | formula to calculate emi in excel | calculate emi in excel sheet | how to calculate emi in excel sheet | how to calculate emi | emi calculation in hindi | emi calculation - excel formula & expert emi calculator [hindi] | excel formulas and functions | excel formulas and functions tutorial | excel tutorial for beginners

свернуть