Excel Sheet Formula 
...Freelancer
I require an excel sheet and mathematician to create a formula for me. I can provide a...have the skills.
The formula is based on the actual AUD/NZD exchange rate for the year period 2000...to today's date, using the weekly charts. The formula is to model an investor's outcome if they applied 
31 
Excel, Matlab & Mathematica, Algorithm, Mathematics 
Aug 18, 2015 
Aug 18, 2015Ended 
$24 
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 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 
JavaScript function IRR (internal Rate of Return) 
...need the IRR calculation formula in Javascript.
I want to use that formula in Salesforce (Visualforce)...(Visualforce) to generate PDF documents
The formula in Google Sheets is:
=irr({D4;0;0;0;0;0;0;0;0;0;E4;0;0;0;0;F4})

11 
PHP, Javascript, Script Install, Salesforce.com, HTML 
Nov 21, 2015 
Nov 21, 2015Ended 
$41 
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 
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 
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 
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 
12 
Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$30 
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 
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 
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 
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 
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 
I have a very small project in excel that needs completion. Basically, here is the problem. Sheet#1 is...Seller Legal Agreement).
## Platform
Windows Excel 
16 
PHP, Windows Desktop, Engineering, Excel, Sales, Powerpoint, Marketing, Technical Writing, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, Microsoft, MySQL, Market Research 
Sep 11, 2009 
Sep 11, 2009Ended 
$55 
Excel VBA function 
...not only 1 of each type of product.
I need a function (until a point is similar to COUNTIF) which goes...tell Excel to perform a formula, and if the cell has a value greater than 1 (>1) I will tell Excel to perform...perform a different formula.
So far so good, but after the function determines whether a cell has 
14 
Visual Basic, Excel 
Jul 6, 2015 
Jul 6, 2015Ended 
$30 