Implement MS Excel RATE function as method/function

...actual formula for the Excel RATE function.
Searching Excel help file reveals the one formula that is...is used for all of Excel's finance functions. (Open Excel, go to help, search for PV, the function, open...rearrange the formula have failed. So now I'm opening up the problem to include Excel rather the... 
1 
PHP, C Programming, Java, Ruby on Rails, Excel 
Jan 15, 2009 
Jan 15, 2009Ended 
$40 
Schedule Productivity Formula in Excel

I need a formula that will generate a standard schedule based on the forecasted hourly covers, per meal...Customers Per Hour. The User will manually enter Hourly Rate on Dining Room Schedule, Hours of Operation, Actual...the workflow and logic and how the data will be used.
Let me know if you have any questions. How 
5 
Statistics 
Aug 8, 2010 
Aug 8, 2010Ended 
$140 
Microsoft Excel Formula Help

...with one Excel formula. Attached are spreadsheets 1 and 2.
I used the lookup function in Excel for this...this formula but it does not work correctly. I need an Excel expert I can go to for this and from time...time to time with potentially larger projects. An excel expert should be able to solve this in 5 mins or 
17 
Excel 
Jan 26, 2014 
Jan 26, 2014Ended 
$22 
simple excel formula

...project...I would appreciate any help you can give a formula for a cell in an excell sheet that simply adds...would appreciative if someone could send me this excel code "gratis"  my usual source cannot be reached...spreadsheet, just one formula for one cell that I can copy down..
At any rate, the attached spreadsheet 
27 
Data Entry, Excel 
Jul 26, 2010 
Jul 26, 2010Ended 
$39 
Microsoft Excel Formula Help

...with one Excel formula. Attached are spreadsheets 1 and 2.
I used the lookup function in Excel for this...this formula but it does not work correctly. I need an Excel expert I can go to for this and from time...time to time with potentially larger projects. An excel expert should be able to solve this in 5 mins or 
7 
Excel 
Jan 26, 2014 
Jan 26, 2014Ended 
$19 
excel formula

Advice how to use if function with multiple conditions, and some lesson. 1 Hr. 
3 
Excel 
Jul 1, 2011 
Jul 1, 2011Ended 
$86 
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 
Excel Formula

...builder and I need an excel file which calculates the amount of material which will be used once I enter the...how much insulation would be used. How many bags of plaster will be used etc...
Details of the products...products is provided.
The doc should be excel. Unless someone thinks of something else.
Need to be 
67 
Data Processing, Data Entry, Excel, Sales, Database Administration 
Jul 31, 2013 
Jul 31, 2013Ended 
$23 
Excel formula

...worksheet in which I need the formula to be corrected. VBA cannot be used. I need to do a search across... Pineapple, Pear.
But for some reason, my formula is ignoring the values in the sheet 3.
Thanks 
6 
Excel 
Aug 28, 2014 
Aug 28, 2014Ended 
$24 
Convert an Excel function into an infpath formula

...appreciate any help converting the above function to an infopath formula, both are attached. 
1 
iPhone, Android, iPad, HTML5, 
Apr 29, 2014 
Apr 29, 2014Ended 
$20 
Need excel formula for find and delete !

...file is being updated everyday. This file is being used to import products into an ecommerce website.
Product...deleted product codes are in B1 column. The excel formula we need, must check all values in B1 then search...Please note I just need a formula which can do this search and delete function. I plan to pay 10 USD for 
2 
XML, Excel 
Sep 24, 2012 
Sep 24, 2012Ended 
$10 
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 
Excel OFFSET function

...the current formula that references a value 6 rows back: =IF(AND(H16W11),1/1,"0") and is used in thousands...same vein, I have two other formula: =MAX(D6:D10) =MIN(E6:E10) is also used in thousands of cells (so the...must be backwards compatible to all versions of Excel upto 97 and tested as such.
## Deliverables
1) 
3 
Excel, Powerpoint, Microsoft Access, Word, Microsoft Exchange, Anything Goes 
Jun 12, 2008 
Jun 12, 2008Ended 
$15 
Microsoft Excel user formula to C++ DLL function.

...three manual array vlookup formulas in Microsoft Excel 2007 to three C++ DLL. functions to reduce calculation 
12 
Visual Basic, Microsoft, C++ Programming 
Oct 21, 2011 
Oct 21, 2011Ended 
$129 
Convert an Excel function into an infpath formula  open to bidding

...appreciate any help converting the above function to an infopath formula, both are attached. 
0 
iPhone, Android, iPad, HTML5 
Apr 30, 2014 
Apr 30, 2014Ended 
 
Excel sheet with easy Formula  1 hour project

I need a guru on Excel, very easy job I only have like 8 formulas to do in Excel.
somme and calculation...with good skills on Excel, I will pay one hour.
this Excel file will be used to manage my website...website inventory and %rate and commission for retailer shops etc...
www.celtek.ca 
31 
Excel 
Apr 25, 2012 
Apr 25, 2012Ended 
$10 
Excel sheet Formula

...Looking for a mortgage payment calculator in an excel sheet. I need it to be part on an PP presentation...Looking for a mortgage payment calculator in an excel sheet.
1. **Loan Amount**
2. **Term (in years):**...**About Your ARM**
**1.? ? ? ? **Length of initial rate term (in months****
**2.? ? ? ? ***Index** **(%)** 
23 
PHP, Windows Desktop, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, Microsoft, MySQL 
May 9, 2009 
May 9, 2009Ended 
$47 
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 functio... 
1 
PHP, Javascript, AJAX, MySQL, Anything Goes 
Sep 27, 2007 
Sep 27, 2007Ended 
$25 
Convert an Excel function into an infpath formula  2

...appreciate any help converting the above function to an infopath formula, both are attached. 
3 
Excel, Sharepoint 
Apr 30, 2014 
Apr 30, 2014Ended 
$24 
Help with excel formula

Hi Jon, I am looking for help with this Excel formula......I need it to return zero into cell C2 if the...0...Here is what I have so far and it seems to function ok with the exception of when there is no value 
1 
Excel, 
Aug 31, 2014 
Aug 31, 2014Ended 
$20 
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 
Formula Help

...spreadsheet for google. I know there is a function in excel but i do not know how to do it. 
1 
Visual Basic, Data Processing, Data Entry, Excel, Microsoft, 
Jan 23, 2015 
Jan 23, 2015Ended 
$40 
Advanced excel formula help

...worksheet in which I need the formula to be corrected. VBA cannot be used. I need to do a search across... Pineapple, Pear.
But for some reason, my formula is ignoring the values in the sheet 3.
I really 
8 
Excel 
Aug 28, 2014 
Aug 28, 2014Ended 
$26 
Excel formula spreed Sheet

...information for There is criteria that needs to be used to calculate
A) Championship Points
B) Club Points

1 
Excel, Microsoft Access 
Nov 1, 2009 
Nov 1, 2009Ended 
$30 
Custom MS Excel Formula

...need a custom formula created for MS Excel, compatible with 2007 and newer. This formula will determine...will be in number of units.
2. The material is used to build a frame: minimum dimensions is 4' x 4'...
3. The formula will optimize material usage and use waste as applicable.
4. The formula will factor 
4 
Visual Basic, Excel 
Apr 4, 2011 
Apr 4, 2011Ended 
$42 
excel time sheet formula

...however, we need this data converting to be used in our excel time sheets.
ive attached the file.

48 
Visual Basic, Excel 
Apr 7, 2013 
Apr 7, 2013Ended 
$60 
Excel OFFSET/IF formula update

...was correct or not. Previously, the spreadsheet used to predict both an upper & lower price that would...win. So, this formula needs rewriting.
## Deliverables
This is the current formula to decide if there...offset2,14)),1/1,"0")
This is the current formula to decide if there was a LOSE (ie the prediction 
7 
PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Aug 6, 2009 
Aug 6, 2009Ended 
$35 
Excel formula needed

I need a excel formular that triggers the following function:
if there is are duplicate entries in 
71 
Data Processing, Data Entry, Excel 
Aug 17, 2011 
Aug 17, 2011Ended 
$272 
Excel Formula Max Borrow

Hi
I need to create a formula to give me the max borrowing capacity by considering the surplus remaining...get a surplus of just above 100
I wanted a formula to present a surplus of 500 left over and alternate...sample file to demo this
I have the formula that uses interest rate and term however as there is going 
20 
Excel 
Jan 26, 2014 
Jan 26, 2014Ended 
$20 
excel morgage payment formula

...capital repayments which is column J. There is a formula for calculating this which we think is based on...the interest rate column C only applies to anything over £30,000. The interest rate for the first 
11 
Data Processing, Accounting, Excel 
Jul 15, 2008 
Jul 15, 2008Ended 
$45 
Math and Excel Formula Program

...Totals and tally up the results from a Folder of excel files. The folder will contain 125 files.
...2. There are only 3 columns of data to be used in each excel file.
**Program 2**
1. Calculate...program will take the first 14 excel file results from the exported excel file from program 1.
2. 
4 
Script Install, Windows Desktop, Software Architecture, Shell Script 
Nov 2, 2012 
Nov 2, 2012Ended 
$138 
Excel formula needed NEW

I need a excel formular that triggers the following function:
if there is are duplicate entries in 
3 
Excel 
Aug 17, 2011 
Aug 17, 2011Ended 
$46 
Excel Formula and Pivot Table

...information for There is criteria that needs to be used to calculate
A) Championship Points
B) Class Points
...calclulating correctly.
This sheet will also be used for furture use and need to be editable. 
3 
Data Processing, Excel, Microsoft Access 
Nov 4, 2009 
Nov 4, 2009Ended 
$76 
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...linked value in AM1 is [$40  $10] $30.
This formula, if possible, needs to be simple enough for us 
38 
Excel 
Jul 13, 2010 
Jul 13, 2010Ended 
$60 
Standard function for Microsoft Excel

Create a formula using Excel's standard functions. The file will also need to be compatible with Apple 
1 
PHP, C Programming, Java, Excel, Electronic Forms, 
Dec 6, 2014 
Dec 6, 2014Ended 
$31 
Excel formula for conditional logit model

...coefficients on fresh data. I need the simplest excel formula, or function writing to perform arrive at the probabilities 
23 
Excel, Statistics, Mathematics 
Jun 7, 2014 
Jun 7, 2014Ended 
$179 
Excel Rate of Return calc

Rate of Return (ROR) template/macro in Excel that uses ongoing imported data received via email. The...I'll provide formula/method and sample data files that will have to be imported into Excel.
One twist...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 
Excel formula converted to vb.net class

...which is used for converting UTM coordinates to Lat/Long coordinates.
I need the formulas used in this...the skilled vb.net programmer.
Se attached excel file.
This job needs to be done tonight.

4 
PHP, Visual Basic, .NET, Engineering, Software Architecture, Software Testing, MySQL 
Oct 6, 2005 
Oct 6, 2005Ended 
$32 
494032 Excel formula help needed

I need help with an Excel 2010 worksheet. I have calculated the nPercentile of a data series. Now I...I need to find a way (preferably a formula) that can calculate an average on the values of the data series...automatically. The problem with the Averageif function is that the criteria cannot be referenced to cells 
1 
Excel, Anything Goes 
Apr 25, 2011 
Apr 25, 2011Ended 
$20 
Excel formula assistance: multiple criteria

...getting one of my formulas correct on an Excel spreadsheet. The formula is basically to select the four lowest...values, based on a variety of criteria.
The formula should select the four lowest interline rates based...necessary to return the interline partner with whom the rate is.
I hope someone can help!
Many thanks in 
13 
Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$30 
Need mathematical formula setup in Excel

...
I need a mathematical equation setup on an excel worksheet that will allow me to easily add my variables...component, which at installed length has Y?/lbf, spring rate of Z?, and the spring travels A? distance. The component...friction of surfaces or other assumptions within this formula. 
8 
Engineering, Mechanical Engineering, Mathematics, Physics 
Nov 3, 2012 
Nov 3, 2012Ended 
$275 
178236 EXCEL SPREADSHEET GURU FORMULA

LOOKING FOR EXCEL SPREADSHEET GURU:
THE SPREADSHEET:
The left column should be a declining interest...interest formula. Basically, you start with the appraised value, and then for the next 16 months (presumably...the house is worth at a 1.5% monthly depreciation rate. By way of example, if we are talking about a million 
0 
Microsoft Access, Anything Goes 
Nov 8, 2007 
Nov 8, 2007Ended 
 
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...
1) Description of the first formula or function:
This formula will concatenate the product name 
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 time sheet formula  2

...however, we need this data converting to be used in our excel time sheets.
ive attached the file.

42 
Visual Basic, Excel 
Apr 11, 2014 
Apr 11, 2014Ended 
$71 
mortgage excel capital repayments formula

Hi
What we want is a formula put in column F to automatically calculate the capital repayments figures...mortgage account put on an excel spreadsheet
column C is the interest rate charged, D is the capital...according to an accounting formula.
This is what we want we want a formula put into column F that will 
22 
Data Processing, Accounting, Excel 
Jul 20, 2008 
Jul 20, 2008Ended 
$93 
Private project or contest #4647876



Visual Basic, Excel, Format & Layout 
Jun 21, 2013 
Jun 21, 2013Ended 

Excel Formula Project  Custom Quote

I need an excel expert to create me a custom formula workbook.
The project is to create a "custom...hardware related products.
I want to create an excel workbook application. The purpose is to give my...be the same thing except in excel, infopath or access. i would prefer excel since i have a little more 
18 
XML, Script Install, Windows Desktop 
May 27, 2006 
May 27, 2006Ended 
$79 
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...will change each month.
We just need a simple formula to calculate both items above. We need the solution 
23 
Data Processing, Excel, Mathematics 
May 6, 2014 
May 6, 2014Ended 
$20 
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...that I will receive.
I would like you to use a formula to calculate the time difference and put that value 
1 
System Admin, Data Entry, SQL, Microsoft Access, MySQL, Anything Goes 
Apr 30, 2009 
Apr 30, 2009Ended 
$20 
Excel VBA Function

I need a VBA function for Excel 2007 that looks something like:
=SET_BACKGROUND_COLOR(RED_VALUE...,GREEN_VALUE,BLUE_VALUE)
so that if the formula is entered into a cell it changes the background 
8 
PHP, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps 
Nov 27, 2009 
Nov 27, 2009Ended 
$32 