Write an Excel Function for interpolation - Most likely in VBA
$10-30 CAD
Maksettu toimituksen yhteydessä
I need a function that does the following:
Input:
x, known_ys, known_xs
For example:
0 | 0
3 | 10
5 | 14
6 | 15
and a point X (4.2)
Y=10+(4.2-3)*[(14-10)/(5-3)]=12.4
Y=y_1+(x-x_1)*[(y_2-y_1)/(x_2-x_1)]
y_1=lower band known Y
x_1=lower band known X
y_2=upper band known Y
x_2=upper band known X
x = interpolated point
---------------
Include all the instructions for adding the function to an excel sheet
All code need to have comments for none VBA Developers
Projektin tunnus: #35871284
Tietoa projektista
Myönnetty käyttäjälle:
Hello, I can start right now. Estimated delivery time: 1 hour. Please initiate a chat, and let's discuss further details. It can work as a function or as a macro, as you like. Best Regards. Zoltan
12 freelanceria on tarjonnut keskimäärin $26 tähän työhön
"""""""""""""""""""""""""""""""""ADVANCE EXCEL VBA EXPERT"""""""""""""""""""""""""""""""""""""""""" "Sir, Excel is my specialty and i can perform any complex task in excel. I am an EXCEL VBA, EXCEL AUTOMATION, EXCEL DA Lisää
Excel vba expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Lisää
⭐⭐⭐⭐⭐⭐ I can start doing it right now ⭐⭐⭐⭐⭐⭐ if u check my reviws u will find me did the same project before also I have all these skills Excel Macros, Excel VBAand Excel trust me ✌️ I can do it very well
--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Lisää
Hello sir I am excel expert. I have handled projects on excel. Please check my review section for previous work.
Hello I am a developer with rich experiences on Excel VBA, macro, C#, .NET For 7+ years. I have full confident to complete your project. I can work by full time for your project and trying to satisfy the requirements. Lisää
Hello! I have vast experience in Excel VBA, Excel and Excel Macros, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing positi Lisää
Hello, Hope you are doing well. I have read your project details. I can write an Excel Function for interpolation in VBA. I can do this project perfectly as per your desired needs. I will provide you an unlimited r Lisää
Hi, Can you share another example. I am pretty sure I can do what you ask but variables and results are not clear to me in project details. Contact if interested. Thanks, Jpa