Write you a custom Excel function you can use in cell formulae as normal
$65
Delivery in
1 day
- Views 43
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Explore the marketplace!
What you get with this Offer
If you are seeing this, then you probably have an issue with an Excel spreadsheet because the function you want to use in a cell formula is not available. Never fret, that's where I come in...
I can write a custom function to your exact requirements that you can use in the cell formula as normal, just as if Microsoft had put it there themselves.
If you can tell me precisely what the formula should do, then I should be able to write it for you; the only real limit would be the time your PC would take to calculate it, which depends on its processing power and the complexity of your formula. I did maths to A level, and then a degree in Economics and Statistics, so I should be able to understand most types of calculation.
I own Office 2013, so the formula will be written in Visual Basic for Applications and delivered to you in a .xlsm file. This will work on all versions of Excel from 2007. You will need to build or copy your spreadsheet into this file for the formula to work; and you will need to enable macros on the workbook, or it won't be permitted to run. My PC has multiple anti-virus and malware scanning tools on it, so I can guarantee the workbook I deliver will be totally safe for you to use in this mode.
I will work on your task and deliver the solution back to you within one working day (Mon-Fri).
I can write a custom function to your exact requirements that you can use in the cell formula as normal, just as if Microsoft had put it there themselves.
If you can tell me precisely what the formula should do, then I should be able to write it for you; the only real limit would be the time your PC would take to calculate it, which depends on its processing power and the complexity of your formula. I did maths to A level, and then a degree in Economics and Statistics, so I should be able to understand most types of calculation.
I own Office 2013, so the formula will be written in Visual Basic for Applications and delivered to you in a .xlsm file. This will work on all versions of Excel from 2007. You will need to build or copy your spreadsheet into this file for the formula to work; and you will need to enable macros on the workbook, or it won't be permitted to run. My PC has multiple anti-virus and malware scanning tools on it, so I can guarantee the workbook I deliver will be totally safe for you to use in this mode.
I will work on your task and deliver the solution back to you within one working day (Mon-Fri).
What the Freelancer needs to start the work
I will need a full explanation of the formula you want: please specify what it should be called, along with any parameters - that's the bits inside the brackets, like the "D4..D6" in "=SUM(D4..D6)" - the calculation depends on. Please give examples of the formula in use, with the parameters and the expected answer in each case - especially any error cases.
For example, if you wanted a formula to calculate x! (the factorial of x, which is 1 * 2 * 3 * ... * x), then you would specify:
Fact(x): compute the factorial of x; examples Fact(1) = 1, Fact(6) = 720, Fact(-3) = #NUM error.
(This function actually exists in Excel already, by the way!)
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies