convert an excel function to a normal math computation???!!

Status
Not open for further replies.

slym34

Board Regular
is there an easy way to do this??? I am trying to convert the RATE() function to a normal math formula, so I can calculate it within another program... Here is the example I am trying to convert to normal math B1 is the function.

<TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=5><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Book1</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=5><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb059465><INPUT onclick='window.clipboardData.setData("Text",document.formFb543420.sltNb142651.value);' type=button value="Copy Formula" name=btCb290334></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=5><TABLE border=0><TBODY><TR><FORM name=formFb543420><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb543420.txbFb965317.value = document.formFb543420.sltNb142651.value" name=sltNb142651><OPTION value==RATE(B4*B5,-((B3+B7)/B6),B7)*12 selected>B1<OPTION value==B4*B5>B6</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value==RATE(B4*B5,-((B3+B7)/B6),B7)*12 name=txbFb965317></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

slym34

Board Regular
yeah i knew it had to do w/ an annuity, but i can't find an interest calculation anywhere... i'm stumped! i know it can be done...

slym34

Board Regular
not really a duplicate post.. the first one was asking how to do it in excel, then expanded. I figured I'd make a new post that more clearly defined in the subject what I was doing, so I could better help others when searching through subjects.. mall cop.

mortgageman

Well-known Member
not really a duplicate post.. the first one was asking how to do it in excel, then expanded. I figured I'd make a new post that more clearly defined in the subject what I was doing, so I could better help others when searching through subjects.. mall cop.

I am guessing that mall cop was meant as an insult - similar to rent a cop

This board has rules. You don't have to like them. I have reported this post as a duplicate post. My experience is that the large majority of this board follows the rules and does not have much respect for those who flout them.

slym34

Board Regular
well good thing it's not a duplicate.. one was to solve something in excel... this one is to learn how to convert from excel functions to math computations.

Smitty

Legend
Welcome to the Board!

well good thing it's not a duplicate.. one was to solve something in excel... this one is to learn how to convert from excel functions to math computations.

The topic is similar enough to be continued in that thread. Especially as it makes clear the origin of the table you posted.

Smitty

Status
Not open for further replies.

Replies
0
Views
106
Replies
2
Views
170
Replies
1
Views
168
Replies
1
Views
132
Replies
2
Views
202

1,190,857
Messages
5,983,249
Members
439,833
Latest member
CDaviess

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back