Write an Excel Function for interpolation - Most likely in VBA

Suoritettu Julkaistu 1 vuosi sitten Maksettu toimituksen yhteydessä
Suoritettu 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

Excel VBA Excel Macros Excel

Projektin tunnus: #35871284

Tietoa projektista

12 ehdotusta Etäprojekti Aktiivinen 1 vuosi sitten

Myönnetty käyttäjälle:

nagyzoltan68

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

$15 CAD 1 päivässä
(176 Arvostelua)
6.9

12 freelanceria on tarjonnut keskimäärin $26 tähän työhön

AccountantArman

"""""""""""""""""""""""""""""""""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ää

$55 CAD 1 päivässä
(216 arvostelua)
6.9
merinsinha

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ää

$30 CAD 1 päivässä
(143 arvostelua)
5.7
konanhenry1111

⭐⭐⭐⭐⭐⭐ 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

$20 CAD 1 päivässä
(57 arvostelua)
5.5
rahulg5466

--------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ää

$30 CAD 1 päivässä
(28 arvostelua)
4.7
azizva

Hello sir I am excel expert. I have handled projects on excel. Please check my review section for previous work.

$20 CAD 2 päivässä
(10 arvostelua)
3.5
duyenanh200219

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ää

$15 CAD 1 päivässä
(1 arvostelu)
2.0
vd58xd24

⚛️ Expert for Macro, VBA, Excel, C#, able to start right now ⚛️ Hello, I am senior developer with enough experiences on Macro, VBA, Excel, C#. For 7+ years. so I have confident to complete your project. I can work by Lisää

$10 CAD 1 päivässä
(1 arvostelu)
1.5
wilfrednjorog

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ää

$30 CAD 1 päivässä
(0 arvostelua)
0.0
AliKhanXZT

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ää

$30 CAD 7 päivässä
(1 arvostelu)
0.0
Jeanphilippe38

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

$30 CAD 7 päivässä
(0 arvostelua)
0.0