Excel
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
08 August 2013
While working on Excel work sheet i came
across :
= pmt
PMT(rate,nper,pv,(fv),(type))
Could some one can clarify what (type)
denotes.
across :
= pmt
PMT(rate,nper,pv,(fv),(type))
Could some one can clarify what (type)
denotes.
08 August 2013
Type is the number 0 (zero) or 1 and indicates when payments are due.
If payments are due at the end of the period set type as 0 (zero).
If payments are due at the beginning of the period set type as 1.
If payments are due at the end of the period set type as 0 (zero).
If payments are due at the beginning of the period set type as 1.
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Payment for sale in March and Sale deed registration to be done in April
- Treatment of TDS under Section 194-IA in case of cancelled property transaction
- GST APPEAL ITC
- PTRC PAYMENT & RETURN FILING (Annually)
- Unable to file 3B monthly return
- Surcharge on discretionary AOP/TRUST for AY 25-26
- TDS U/S 194S VDA
- REGARDING ITR OF TRUST
- TCS Return Without PAN
- Advance tax payment after 15th Mar 15
- Query regarding applicability of UDIN on MCA forms signed using DSC by a Chartered Accountant
- GST ON PERSONAL MOTORCAR SOLD
- Cash gift by grand mother to her grand daughter
- APPLICABILITY OF RCM ON MAN POWER SUPPLY BY UN REGISTERED PERSON TO REGISTERED PERSON.
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Spice form, ? mark comes in address
- Tds on GST in connection with sale to public company
- B2B Amendment
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
