|Excel RATE() function defined in Ruby
||...over a function I have defined in Ruby. I'm wanting to clone Excel's built-in RATE() function and can't...This job will be considered complete when the function is working flawlessly.
||Ruby on Rails, Algorithm, Software Architecture
||Dec 2, 2010
||Dec 2, 2010Ended
|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
||PHP, C Programming, Java, Ruby on Rails, Excel
||Jan 15, 2009
||Jan 15, 2009Ended
||Nov 25, 2011
||Nov 25, 2011Ended
|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
||Sep 27, 2007
||Sep 27, 2007Ended
|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.
||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
||Education & Tutoring
||Nov 4, 2010
||Nov 4, 2010Ended
||Please work on this function.
||Jan 5, 2014
||Jan 5, 2014Ended
||Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified
||PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Feb 13, 2004
||Feb 13, 2004Ended
||...modify Excel function shown in the link below: http://tinyurl.com/ycpzmw9 The current function removes...are upper case letters A-Z and numbers. The new function should also allow lowercase letters a-z and the...Worker Legal Agreement).
Microsoft Excel, VBA
||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
||...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
||Nov 26, 2008
||Nov 26, 2008Ended
||Please work on this function.
||Mar 10, 2014
||Mar 10, 2014Ended
|Call Excel xla function in VB (MS Access)
||...want to call Excel xla functions in MS Access.
CUMPRINC function (you need to...to enable Excel Analysis ToolPak-VBA first)
We want to call "cumprinc()"..."cumprinc()" function in MS Access
we tried follows, but both didn't work
Public Function xx(rate
||PHP, Visual Basic, Engineering, Software Architecture, Microsoft Access, Software Testing, MySQL
||Apr 14, 2004
||Apr 14, 2004Ended
||I would like an excel function that will produce a list which concatenates as follows:
||PHP, Software Architecture
||Sep 25, 2013
||Sep 25, 2013Ended
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
||Jul 13, 2010
||Jul 13, 2010Ended
||5 excel functions required for 10 to complete the task
||Apr 25, 2015
||Apr 25, 2015Ended
|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
||Jul 4, 2012
||Jul 4, 2012Ended
|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
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||May 8, 2008
||May 8, 2008Ended
|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
||Data Processing, Excel, Mathematics
||May 6, 2014
||May 6, 2014Ended
|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
||PHP, Engineering, Sales, Marketing, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Apr 5, 2006
||Apr 5, 2006Ended
||Here is what I need: I have an Excel spreadsheet which contains a column with values in its cells ranging...
Windows 2000 Visual Basic 6.0 Excel 2000
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||May 1, 2003
||May 1, 2003Ended