Closed

Transform an excel formula to VBA script

Hello,

I have a formula which I want you to transform it to VBA code in order to iterate a list of inputs. The formula needs to work in google sheet.

I enclose you a case file, in order to understand better. The formula is

=$C6*MAX(0,DAYS(MIN($B6,EOMONTH(E$5,0)),MAX($A6,E$5)))/DAYS($B6,$A6)

and corresponds to the value of cell E6.

Columns A,B,C are the input data. I want the script to give me line 10 (green line) as a result.

My budget is 10$

Thanks for your time

Skills: Excel, VBScript, Visual Basic, Visual Basic for Apps

See more: vba formula result value, excel convert formula to value automatically vba, vba vs excel formulas, excel vba if formula in cell, excel automation formulas, excel formula to vba converter online, how to write excel formula in vba code, excel vba convert formula result to text, start vba script excel, run vba script excel, excel vba script modify existing vba, vba script excel xml, vba script excel current worksheet, vba script project excel, can vba script run outside excel, simple excel vba script, excel using custom vba script, excel vba script find text, excel nearest neighbor vba script, paste formula vba excel

About the Employer:
( 4 reviews ) TOULOUSE, France

Project ID: #19294717

16 freelancers are bidding on average $20 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$35 USD in 1 day
(319 Reviews)
7.9
valor312

VERY EASY FOR ME, I can do it within 30 min Hi, Nice to meet you. Please see product I made recently using VBA and C# excel management https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f http More

$30 USD in 1 day
(49 Reviews)
5.9
lightingdavid

Hello. I have good skills in "Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project des More

$25 USD in 1 day
(100 Reviews)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$30 USD in 1 day
(119 Reviews)
5.9
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$25 USD in 1 day
(37 Reviews)
4.5
maguirrer

Hello, I can help you with this project, please send me a message with some details liks what are the values on gray (I thought it was the days of the range for each month, but the total doesnt match). I can start work More

$10 USD in 5 days
(26 Reviews)
3.9
rickygzz85

I will create a VBA macro to achieve what the formula describes I offer - Quality. Everything organized, excellent grammar, proper indentation comments on the code. - Availability to work full time on this proj More

$15 USD in 1 day
(13 Reviews)
3.3
TransGlobal365

Greetings! Are you looking for high quality native manual language transcription? If so, we are here to assist you with your all transcription needs and giving you the guarantee of 100% perfect result without a single More

$10 USD in 0 days
(2 Reviews)
2.2
ArturQQ

I can help you with you vba transition in 5 hours, when I get home, if it will be ok to wait, feel free to accept my bid.

$10 USD in 1 day
(2 Reviews)
1.4
sagom

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo More

$20 USD in 1 day
(1 Review)
1.4
arashbahrami1

Hi, I am expert in VBA and web application development and also have experience over 10 years in security and quality assurance fields. I think I can do it for you as soon as possible. In order to see my customers p More

$15 USD in 2 days
(1 Review)
0.0
espanajv

Hi, This is too easy, Really please contact me. You'll have your response regarding today is saturday probably in 2 hours. But, its really really too easy. Have fun. And well with my bid thanks for the beer. Chea More

$15 USD in 1 day
(0 Reviews)
0.0
Bassemashraf20

Welcome Sir My name is Bassem Ashraf, Bachelor of Engineering. I work well on AutoCAD, Microsoft Word, Microsoft Excel, Photoshop, excellent translation, printing, Data Entry. It will save you less time, less money More

$25 USD in 1 day
(0 Reviews)
0.0
amitbecs08

Hi Sir, I can complete this task in required time frame. Hoping for positive response from you. Regards Amit Bhadula

$10 USD in 1 day
(0 Reviews)
0.0
belleroandres

Hello I am interested in this project I have experience for more than 10 years in vba, in excel, acces and visual basic. my main achievements are costing system, sending mail, alarm, file processing. thank you.

$25 USD in 10 days
(0 Reviews)
0.0
NoSonforhim

I have 20 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer

$22 USD in 1 day
(1 Review)
0.0