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)...rearrange the formula have failed. So now I'm opening up the problem to include Excel rather then, ... 
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...manually enter Hourly Rate on Dining Room Schedule, Hours of Operation, Actual Hours. Ideally, the algorithm...Agreement).
## Platform
The application should function on all existing Windows platforms, XP/Vista/7 
5 
Statistics 
Aug 8, 2010 
Aug 8, 2010Ended 
$140 
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 
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 
Excel Formula 
The Actual File is attach. The date will be filled up by me and I would want the yellow fill cells to 
2 
Data Processing, Data Entry, Excel 
Apr 30, 2012 
Apr 30, 2012Ended 
$13 
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 
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...compression spring behind the component, which at installed length has Y?/lbf, spring rate of Z?, and the...friction of surfaces or other assumptions within this formula. 
8 
Engineering, Mechanical Engineering, Mathematics, Physics 
Nov 3, 2012 
Nov 3, 2012Ended 
$275 
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 
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 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 
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 
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 
 
NEED MATHEMATICAL HELP AND EXCEL FORMULA ASAP! 
...
I need a mathematical equation setup on an excel worksheet that will allow me to easily add my variables...compression spring behind the component, which at installed length has Y?/lbf, spring rate of Z?, and the...friction of surfaces or other assumptions within this formula.
Input Variables (All variable shall be 
4 
Engineering, Mechanical Engineering, Mathematics, Physics 
Nov 3, 2012 
Nov 3, 2012Ended 
$103 
Excel Macro or Formula 
Please see the attached Excel spreadsheet. I need a macro or formula to take the Input and give the...in a new worksheet. Sample contains a few rows, actual data will be much larger. 
14 
Data Processing, Excel 
Jul 23, 2013 
Jul 23, 2013Ended 
$23 
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 
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 
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 
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 
Feedback excel formula 
...criteria should be in columns I,J,K,L,M and the actual text comments should be listed verbatim in the 
8 
PHP, Windows Desktop, Project Management, Engineering, Software Architecture, Software Testing, Microsoft, MySQL 
Feb 14, 2008 
Feb 14, 2008Ended 
$47 
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 
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 
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 
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 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 
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 
356375 online shop with cms behind 
Need to support the function to get(add)(new) articles and update prices for existing articles from...from 1 or more excel file(the excel with new prices and wares i get from the providers of stock). I need 
0 
PHP, Graphic Design, SEO, eCommerce, MySQL, Anything Goes 
Oct 5, 2009 
Oct 5, 2009Ended 
 
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 
...posted and Bidder failed to complete now placing us behind schedule for a Presentation within 24 Hours

3 
Data Processing, Excel, Microsoft Access 
Nov 4, 2009 
Nov 4, 2009Ended 
$76 
Excel formula to calculate loan payment  ADJUSTABLE interest rate 
Very simple, need one formula to complete online calculator project, using Excel. I just need the correct...correct, working formula. Winning bidder will not be required to edit any documents or post anything online...online. Provide the correct formula, and the job is complete. This should take minimal to no time for 
8 
Data Processing, Data Entry, Excel 
Apr 23, 2015 
Apr 23, 2015Ended 
$23 
Budget versus Actual Report 
I am trying to create a budget versus actual report in MS Excel. There are 2 worksheets in the file presently...Sheet 1: ACTUAL  OCTOBER by part/customer for Oct.
Sheet 2: BUDGET
I need a macro or formula to lookup...lookup the Actual Sales from the ACTUAL sheet, sum them by customer and by part, then put the total in 
1 
PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX 
Nov 5, 2007 
Nov 5, 2007Ended 
$106 
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 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 
Date Sensitive Conditional Formula on Excel 
$30 for an Excel formula
I have an Excel charity database with a list of participants. I am visiting...create a Date Sensitive Conditional Formula on Excel.
The formula has to analise:
Current Date,
Frequency...in Bordeaux colour if it is behind the scheduled visit.
In the Excel database Colum A has a date 
8 
Excel 
Jan 21, 2013 
Jan 21, 2013Ended 
$32 
Very Simple Excel Look Formula 
Ok, lookup formula. I have a cell with a bunch of numbers not sorted (either descending or ascending)...be a shree minute job max.
Included is the actual excel file so you can see what I mean.
Thanks 
5 
PHP, Translation, Data Entry, Engineering, Excel, Testing / QA, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Academic Writing, Word, Website Testing, Microsoft Exchange, Article Rewriting, MySQL, Usability Testing, Amazon Web Services, Website Management, Web Hosting 
Feb 13, 2004 
Feb 13, 2004Ended 
$3 
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 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 
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 
 
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 
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 
Need excel formula for find and delete ! 
...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 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 
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 
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 
Excel Formula 
...would export a list from my EPOS and then need a formula that would use either the barcode or the product 
25 
Excel 
Feb 19, 2013 
Feb 19, 2013Ended 
$46 
Excel formula 
...attached a sample worksheet in which I need the formula to be corrected. VBA cannot be used. I need to... 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 
Formula  Home Loan  Fortnightly formula needed 
...(fortnightly) formula.
I have the monthly formula below.
Job
Provide the formula for fortnightly...(biweekly). Would also need to be provided in a excel spreadsheet so I can check it works.
I will...emyrepayments/default.asp
Monthly Formula
A = (rate /100)/12 (because its monthly so 12 month 
15 
Excel, Mathematics 
Dec 8, 2012 
Dec 8, 2012Ended 
$37 
Excel formula 
Single formula problem 
1 
Excel, 
Aug 13, 2014 
Aug 13, 2014Ended 
$27 
an excel formula 
I am looking for an expert to create a formula to populate one of the columns.
A(date), 
63 
Excel 
Mar 21, 2015 
Mar 21, 2015Ended 
$22 