Excel RATE() function defined in Ruby

...over a function I have defined in Ruby. I'm wanting to clone Excel's builtin RATE() function and can't...This job will be considered complete when the function is working flawlessly. 
1 
Ruby on Rails, Algorithm, Software Architecture 
Dec 2, 2010 
Dec 2, 2010Ended 
$30 
Implement MS Excel RATE function as method/function

Need the actual formula for the Excel RATE function.
Searching Excel help file reveals the one formula...Excel's finance functions. (Open Excel, go to help, search for PV, the function, open that topic, scroll down)...problem to include Excel rather then, here is formula make rate the subject (rate =).
The way I'm 
1 
PHP, C Programming, Java, Ruby on Rails, Excel 
Jan 15, 2009 
Jan 15, 2009Ended 
$40 
JavaScript function IRR (internal Rate of Return)

I need the IRR calculation from the excel formula to my website in Javascript.
=+(1+IRR(C23:C83;0 
5 
PHP, Javascript, Script Install, HTML 
Nov 25, 2011 
Nov 25, 2011Ended 
$55 
168666 Convert Excel RATE() into Code

...the Excel function RATE(). The RATE() function is used in Excel to calculate the comparison rate (or...(or effective interest rate) where the repayment value, no. of repayments and initial loan value are known...a loan amount and interest rate). You will see that the 'Comparison Rate' is currently not functioning 
1 
PHP, Javascript, AJAX, MySQL, Anything Goes 
Sep 27, 2007 
Sep 27, 2007Ended 
$25 
208802 Exchange Rate upload

The current exchange rate upload into our system is a manual process and following steps are involved...copy and paste function which may casue errors.
This template should also have the function to clear the...template for upload
The template can be either in Excel (xls) format and or Tab delimted (Txt) format. 
0 
XML, Visual Basic, Anything Goes, HTML 
Mar 19, 2008 
Mar 19, 2008Ended 
 
Modified Internal Rate Of Return

...Internal Rate of Return (IRR) would be the correct formula to use. I can't use the normal IRR function in...in Excel since it can only handle one negative number in a fixed stream of cash flows. Excels Modified...Modified Internal Rate of Return (MIRR) formula allows for multiple negative cash flows, but I'm not clear 
3 
Education & Tutoring 
Nov 4, 2010 
Nov 4, 2010Ended 
$96 
Excel function

Please work on this function. 
1 
Excel, 
Jan 5, 2014 
Jan 5, 2014Ended 
$5 
Excel Function

Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified 
19 
PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Feb 13, 2004 
Feb 13, 2004Ended 
$24 
Excel function

...modify Excel function shown in the link below: http://tinyurl.com/ycpzmw9 The current function removes...are upper case letters AZ and numbers. The new function should also allow lowercase letters az and the...Worker Legal Agreement).
## Platform
Microsoft Excel, VBA 
80 
PHP, Visual Basic, .NET, Script Install, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps 
Apr 10, 2010 
Apr 10, 2010Ended 
$36 
Excel function

Please work on this function. 
1 
Excel, 
Mar 10, 2014 
Mar 10, 2014Ended 
$15 
Call Excel xla function in VB (MS Access)

...want to call Excel xla functions in MS Access.
For example:
CUMPRINC function (you need to...to enable Excel Analysis ToolPakVBA first)
=CUMPRINC(5,5,5,5,5,0)
=4.1672
We want to call "cumprinc()"..."cumprinc()" function in MS Access
we tried follows, but both didn't work
1)
Public Function xx(rate 
13 
PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL 
Apr 14, 2004 
Apr 14, 2004Ended 
$25 
Excel function

...the data from an other sheet using the VLOOKUP function.
Suppose to have a list of articles in the "Sheet...have different size and resolution.
So I need Excel to resizes them keeping the aspect ratio, manages...least I guess) and Excel look for the file/s in the folder.
If the file exists Excel analyzes it, resizes 
7 
Excel 
Nov 26, 2008 
Nov 26, 2008Ended 
 
Excel function

I would like an excel function that will produce a list which concatenates as follows:
Concatenatelist([Title] 
3 
PHP, Software Architecture 
Sep 25, 2013 
Sep 25, 2013Ended 
$55 
Excel Function

Hi all,
We are looking for an excel expert to help us with a functions/formulas for one of our clients...clients eCommerce solution.
The function we are needing has to link cells AM1 (values in red) to G2...on which values/cells we are linking up, as the excel document will have more than 100 values that need 
38 
Excel 
Jul 13, 2010 
Jul 13, 2010Ended 
$60 
Excel IF function

...create 2 Excel IF functions. It is hard for me to explain but here is an example and using the Excel file...provided this will help explain what I need
Excel function 1
Start in cell CV3
=IF A3="ALBANY"...continue until Wyong 2100 ( see line A265 )
Excel function 2
Start in cell CW3
=IF A3="ALBANY" 
1 
Excel, 
Jul 4, 2012 
Jul 4, 2012Ended 
$27 
Calculate Excel data using SUMIF, SUMIFS functions and calculate conversion rate

...We are trying to add data using SUMIF or SUMIFS function:
1) One column for the criteria has the date 
23 
Data Processing, Excel, Mathematics 
May 6, 2014 
May 6, 2014Ended 
$20 
Excel Rate of Return calc

Rate of Return (ROR) template/macro in Excel that uses ongoing imported data received via email. The...sample data files that will have to be imported into Excel.
One twist is there are two different sets...current supplier. Both say they’ll provide me? with Excel readable files...which I take to mean CSV files 
8 
PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
May 8, 2008 
May 8, 2008Ended 
$246 
Add rate

Here is what I need: I have an Excel spreadsheet which contains a column with values in its cells ranging...
## Platform
Windows 2000 Visual Basic 6.0 Excel 2000 
14 
PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL 
May 1, 2003 
May 1, 2003Ended 
$19 
RATE/PRICE quotes online/email

I want to do RATE QUOTES through email/online system. I would like to program this for online use (PHP...need to be able to quote customers that are seeking rate/prices etc. The program has to be accessible though...the client accepts the quote it has to be some function that sends the deal to supervisor for acceptance 
1 
PHP, Engineering, Sales, Marketing, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting 
Apr 5, 2006 
Apr 5, 2006Ended 
$1062 
Calculate YTM

The bidder should be able to use PHP to create a class which reads values from parameters in order to calculate the Yield to Maturity value. 
13 
PHP 
Nov 20, 2013 
Nov 20, 2013Ended 
$33 
Private project for RomaSant (advanced rate function)

Private project for RomaSant (Advanced rate function). 
1 
PHP, MySQL 
Apr 17, 2010 
Apr 17, 2010Ended 
$45 
286537 Excel Function  DeleteRows

We need some help with an Excel function that would delete the entire row(s) based on values of certain...should be fairly simple for someone familiar with excel. PMB any questions or concerns before bidding on 
1 
Visual Basic, Data Entry, SQL, Microsoft Access, Anything Goes 
Feb 5, 2009 
Feb 5, 2009Ended 
$10 
Make Excel Function (VBA)

Hi Guys,
I need a function, see below.
'The function should take the colour from the product name
...from the array
'  Join the array with ""
Function COLORFROMNAME(cVal As String) As String
'...If
Next
COLORFROMNAME = result
End Function 
3 
PHP, Visual Basic, Software Architecture, Visual Basic for Apps 
Nov 11, 2014 
Nov 11, 2014Ended 
$491 
Add some Excel function

...need a working file ("Planning.xlsx) with some function (create list, change color in some case)
The 
6 
Data Processing, Data Entry, Excel 
Nov 21, 2012 
Nov 21, 2012Ended 
$59 
VB function for Excel

Excel has built in functions such as COUNTIF(range, criteria) and SUMIF(range, criteria, sum_range)....MinIf(Check_Range, Criteria, Data_Range) and MaxIf. Each function should accept ranges and a criteria, similar to...And( $ <=10, $ >3) OR ($ = 6.55). Ideally the function would work like SumIf in that the criteria could 
8 
PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL 
May 6, 2006 
May 6, 2006Ended 
$20 
Excel function in VBA

...create a function In Excel  I should be able to import a text file  and then import 2 or 3 excel files...imported excel files  export the "modified excel file" to a text file  Ready !
This excel function are 
21 
Visual Basic, Excel 
Jul 12, 2012 
Jul 12, 2012Ended 
$196 
315982 Excel Function

...basic excel formula to calculate the actual time difference between two dates.
Please use an excel formula...NO macro's or VB scripts.
I have attached an excel doc to show what I required.
The Create and Resolved 
1 
System Admin, Data Entry, SQL, Microsoft Access, MySQL, Anything Goes 
Apr 30, 2009 
Apr 30, 2009Ended 
$20 
Excel Formulas/Function

**Deliverables: Two Excel Formulas or Excel Functions (Preferred), as described below:
I need two...two closely related Excel formulas that will take the text data from a spreadsheet and modify it to create...below.
1) Description of the first formula or function:
This formula will concatenate the product 
17 
PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Dec 15, 2008 
Dec 15, 2008Ended 
$34 
Excel Function  Hyperlink

...review the attached spreadsheet.
I'd like a function that will create a hyperlink from a spreadsheet...coder's Seller Legal Agreement).
## Platform
Excel 
2 
PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX 
May 18, 2006 
May 18, 2006Ended 
$4 
User Defined Excel Function

Create a userdefined function that can be used to output the value in the lookup table. Such as: coxsprague...Agreement).
## Platform
Windows 7.0 MS Office Excel 2007 
2 
Engineering, Software Architecture, Software Testing 
Aug 12, 2010 
Aug 12, 2010Ended 
$8 
Need to add an Excel function

Need to add an Excel function that does the following:
I have a validation list in one cell that i...supposed to be easy, but it just don't know the function for it.
this is a onetime job.
please bid 
9 
Excel 
Oct 25, 2014 
Oct 25, 2014Ended 
$3 
excel function for distance calculator

...within india into km (around 4000 destinations) in excel 
10 
Excel, Google Earth 
Nov 28, 2014 
Nov 28, 2014Ended 
$18 
Excel Sheet with Send function

We have an Excel workbook with several sheets contained within relating to Maintenence to a particular 
21 
Visual Basic, Excel 
Nov 13, 2012 
Nov 13, 2012Ended 
$77 
Excel Pivot Table Function

...write a function for me along the lines of the following.
1. It is a worksheet function
2. It...FIELD.
I tried to write the function as follows:
Public Function GetPortfolios() As String
Dim...GetPortfolios & pvtItem.Name & " "
End If
Next
End Function
Given the attached screen shot, I would expect 
1 
PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX 
Oct 19, 2004 
Oct 19, 2004Ended 
$5 
447130 Customize an Excel Function

I have attached an Excel visual basic script that has 95% of the functionality I am seeking.
Attached...Attached is an Excel spreadsheet (SERP Rankings.xls)  the script can be viewed in Excel's Visual Basic editor...modification of this script to create a custom function (i.e. =findrank) to work with the second attached 
0 
Visual Basic, SEO, Excel, Anything Goes, Website Management 
Oct 7, 2010 
Oct 7, 2010Ended 
 
282298 Excel Import Function

...content of the site with the information I have in excel. i.e house# address city state zip price etc.
I...create a PHP/MySQL feature that would read any excel file and populate the info into the database. This 
1 
PHP, MySQL, Anything Goes 
Jan 20, 2009 
Jan 20, 2009Ended 
$14 
Simple Excel IF function help

Can someone help me with my Excel function.
I have tried this: =IF(G1<>"" & H1<>"";",";"")
I try 
2 
Excel 
Dec 1, 2013 
Dec 1, 2013Ended 
$13 
Excel selection function

I have an excel worksheet with a table with values. depending on the length and width a different value...be selected.
## Deliverables
Please find the excel sheet in the attached file. There are 2 examples 
1 
Windows Desktop, Linux, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, UNIX 
Mar 17, 2011 
Mar 17, 2011Ended 
$9 
Excel Function/Macro

I need to sort 3 columns of data.
First column is Emails (A), second is MD5 hash (B) and third is MD5 hash (C).
Column A  Emails contains 6 values in example. (Realistically 30000)
Column B  MD5 Hash contains 6 values in example. (Realistically 30000, ALWAYS The same as Column A)
Column C  MD5 Hash contains 3 values in example. (Realistically 500)
Step 1:
I need to Match the MD5 from Co... 
38 
Excel 
Jul 15, 2010 
Jul 15, 2010Ended 
$36 
excel function design

...other cell.
attaching example
excellent in excel only bid

12 
Excel 
Jan 22, 2015 
Jan 22, 2015Ended 
$19 
Stock Quote Function in Excel

Wanted: a function that returns the value of the last trade price for that stock given a stock symbol...symbol . This function should be available in Excel. I'd prefer the function be available via an addin so...You can assume an internet connection when the function is called. I don't have a strong preference for 
11 
PHP, Visual Basic, Windows Desktop, Engineering, Software Architecture, Software Testing, Microsoft, MySQL, Google Chrome, Apple Safari 
Jun 3, 2002 
Jun 3, 2002Ended 
$88 
Clone Excel function  PRICE

code the Excel PRICE function in C#
The date calculations need to be stored in a class as follows
...in a High Performance implementation of the Excel Function YIELD
Any other questions, pls ask 
15 
C Programming, Java, Visual Basic, .NET, J2EE 
Apr 18, 2008 
Apr 18, 2008Ended 
 
Standard function for Microsoft Excel

Create a formula using Excel's standard functions. The file will also need to be compatible with Apple iWork (Numbers). 
1 
PHP, C Programming, Java, Excel, Electronic Forms, 
Dec 6, 2014 
Dec 6, 2014Ended 
$31 
Excel search function

I need to modify the search function on an existing excel database I have. Good vb skills needed. No 
4 
Visual Basic 
Jan 7, 2014 
Jan 7, 2014Ended 
$37 
Inventory & Rate Checker  Overstock.com

Code in excel to check inventory and stock of product on Overstock.com. 
9 
Excel, Web Scraping, Data Mining 
Apr 10, 2014 
Apr 10, 2014Ended 
$162 
excel function and xml output

...field 112 values
Task 1: Need a script / function etc that transforms this initial table to a new 
7 
PHP, Perl, XML, Visual Basic 
Sep 17, 2013 
Sep 17, 2013Ended 
$71 
413111 excel function help

EXCEL  In need of help to search a range for a string and return the cell location.
Probably a simple...simple function but has me stuck.
Preferrably a function and not a macro.
explanation attached 
1 
Excel, Anything Goes 
May 11, 2010 
May 11, 2010Ended 
$10 
62705 Improve Excel Function

I need a function in excel improved upon. 
1 
PHP, Visual Basic, Anything Goes 
Nov 18, 2004 
Nov 18, 2004Ended 
$10 
Excel function in VBA

...create a function In Excel  I should be able to import a text file  and then import 2 or 3 excel files...imported excel files  export the "modified excel file" to a text file  Ready !
This excel function are 
34 
Visual Basic, Excel 
Jul 3, 2012 
Jul 3, 2012Ended 
$210 
Excel Lookup Function

We need the code for an Excel Lookup Function to reference color codes on another database file. Example...“black”, “red”, etc. We want to be able to run the function so that these color codes lookup File 2 and output...commas, in one field.
We would also like the function to be able to lookup and output sizes from another 
39 
Data Processing, Data Entry, Excel 
Oct 25, 2011 
Oct 25, 2011Ended 
$64 