excel formula

738 views 2 replies

hw to give excel formula in excel sheet 

for example if  i want to calcutale interest for the following

                                                                                                                                              

 

from  to  Amt rate of interest  total Interest for days
January 4, 2009 June 30, 2009         100,000.00 8% P A  

                       

what formula i should set so that i can get the figure of total interest ( i dont want to count total days manully it shold be come in the formula also  )

Replies (2)

U better used the rate fnction in excel. For rounding use Round function in excel. All functions r available in insert menu. Also self explanatory exmples with all respective functions

Hi... Sumit I have attach here for your problem solution pls find. And further any quarry pls tell me. Regards Sagar Zankhariya

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 30 June 2026
2 posts Article assistant and Articleship completed students

Chirag N Shah & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
24 June 2026
Senior Account (VA Client Operations)

Karbon Business

Bengaluru

CA Inter

View Details