Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Cobol equvivalent for Excel function RATE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe COBOL
Author Message
Sowmya Ramachandra

New User


Joined: 11 May 2007
Posts: 4
Location: Canada
PostPosted: Tue Aug 26, 2008 3:35 am    Post subject: Cobol equvivalent for Excel function RATE
 Reply with quote
Hi,

Can anyone let me know the cobol equivalent formula for the below excel function please. icon_question.gif

(RATE(C5,-G5,D5,,,10%)*12)
Back to top
View user's profile Send private message
References
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 1930
Location: Israel
PostPosted: Tue Aug 26, 2008 10:47 am    Post subject:
Reply with quote
Take a look at COBOL's function ANNUITY.

Ofer
Back to top
View user's profile Send private message
Sowmya Ramachandra

New User


Joined: 11 May 2007
Posts: 4
Location: Canada
PostPosted: Wed Aug 27, 2008 10:26 pm    Post subject:
Reply with quote
Thanks for you update.

Is the Annuity function used to calculate APR. The rate function metioned above is to calculate APR.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Senior Member


Joined: 20 Oct 2006
Posts: 1618
Location: germany
PostPosted: Wed Aug 27, 2008 10:57 pm    Post subject:
Reply with quote
how about looking the the manual for your version of cobol and the Language Environment APIs
(documents starting with CE... are LE manuals)
and see what function is available at your site.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe COBOL All times are GMT + 6 Hours
Page 1 of 1