# Excel VBA Simple Logical Funtions Seperated By GOTO Line Numbers

Im using VBA in Excel to work on a fairly simple flow chart that i have created. I have 5 Variations of the flow chart that i would like to eventually test as part of my larger project. The data set im using is simply a range of numbers from Cell A2:A13. The numbers are to two decimal places. Because i have 5 flow chart variations of testing this number range i decided to Code one and then because it works logically in sequence i can re-arrange the various sections and complete the rest easier. Its just using general Logic Functions. If the result is TRUE i would like to then GOTO another section if FALSE another section or possibly just to display "FALSE" Here are the Six Logical Function Tests i would require you to complete 1) Does the range (A2:A13) contain any duplicate numbers - if yes display FALSE in Cell D9, if no GOTO next Logical Test 2) Are 4 or more of the numbers in the range between 1.00 and 1.99 & are there 0 numbers between 2.00-2.99 - if yes display FALSE in Cell D9, if no GOTO one of the other Logical Tests below 3) Are there any numbers in the range between 1.50-2.00 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 4) Are there any numbers in the range between 2.50-2.80 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 5) Are there specifically 3 to 5 numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 6) Are 6 or more numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test Basically once i have the logic funtions coded for each stage i can piece all my Flow Chart Variations togther using a GOTO command, if that makes sense? If you could clearly show the Logical Funtions above seperated and with a GOTO Line Number at the start of each one i can use this to work with my drawn flow charts. Does this make sense? If you require more information im happy to talk you through some more of what i require. Regards, Andrew

Om arbejdsgiveren:
( 0 bedømmelser ) Dudley, United Kingdom

Projekt ID: #16097175

## Tildelt til:

jaylancer43

Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-stor Flere

£210 GBP in 3 dage
(548 bedømmelser)
8.1

## 27 freelancere byder i gennemsnit £122 på dette job

Webxpert4u

Hello, I am ready to fix excel using VBA. Can you send me excel file ? Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writ Flere

£210 GBP in 5 dage
(156 bedømmelser)
7.2
deepbluetech

Hi Andrew, I have studied the flowchart you have described. I can implement the logic using Excel VBA and deliver within 3 days. Cheers, Arul

£180 GBP in 3 dage
(250 bedømmelser)
7.3
schoudhary1553

Greeting, I have understood your Excel VBA Simple Logical Funtions Seperated By GOTO Line Numbers task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of e Flere

£180 GBP in 3 dage
(231 bedømmelser)
7.3
cugamelover

I'm an Excel expert. I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel usi Flere

£180 GBP in 5 dage
(209 bedømmelser)
7.2
P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£100 GBP in 3 dage
(226 bedømmelser)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£100 GBP in 2 dage
(187 bedømmelser)
6.7
rengrish

Hi I have 10+ years of experience in Excel & VBA. I can complete this job right now on the spot. Could you please attach the spreadsheet ? Please check my past reviews. I can complete the job within hour or tw. Thank Flere

£70 GBP på 1 dag
(143 bedømmelser)
6.0
shanki161

>>>>>Genuine and Reliable<<<<<< Let us do this for you. We are up for a DEMO to show our expertise on this [login to view URL] will follow all the instructions and always available for 24*7 support on skype(voice+text+video). Flere

£277 GBP in 5 dage
(30 bedømmelser)
5.3
langlangFan

I am VBA, Excel expert, Already have good experience in my profile. I can help you what you need from VBA, Excel. Feel free to contact me. Good Luck !

£150 GBP in 3 dage
(8 bedømmelser)
5.5
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Flere

£116 GBP in 4 dage
(55 bedømmelser)
5.5
ExtraNet

VBA expert here, with both an academic and professional background in IT. I've gone through your entire description and it's pretty straight-forward. There are a couple of minor details as to the approach you'd prefer Flere

£30 GBP på 1 dag
(12 bedømmelser)
4.1
yh2013

I worked many projects for Excel that include macros (VBA). Check my portfolio. I have the required expertise.

£88 GBP in 3 dage
(14 bedømmelser)
4.3
chintuag

Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ri Flere

£166 GBP in 2 dage
(8 bedømmelser)
3.9
£138 GBP in 3 dage
(14 bedømmelser)
3.6
periyannas

Hi, Nice to know your requirement. I am an excel vba expert, and have delivered 4 vba projects in the past 20 days. Would like to do the job mentioned. It will take three to four hours for me to complete the task you h Flere

£80 GBP in 3 dage
(8 bedømmelser)
3.2
Denishpatel96

Need to know more details for exact bid price for this project. Hope to hear from you soon. Thank you.

£23 GBP in 2 dage
(4 bedømmelser)
2.8

FREE SUPPORT AND UPDATE AFTER RELEASE I am Software Engineer; +10 years in: - Model relational database (Oracle, MYSQL, Postgress, MsAccess) / Syntax SQL - Software developer (ASP, PHP, Visual Bacic) - Excel a ( Flere

£210 GBP in 5 dage
(2 bedømmelser)
2.8
haleem0786

i have good command over Ms excel especially pivot table, charts, advance formulas, VBA, Macro etc. Thanks

£150 GBP in 3 dage
(5 bedømmelser)
2.4
£66 GBP in 3 dage
(1 bedømmelse)
2.4
dhivya1enigma

I have sound knowledge in Excel Macro. I would be completing the job in time. Bidding minimum to win. I have read your requirement kindly share the excel sheet with data so that I can understand the logic flow complete Flere

£40 GBP in 3 dage
(3 bedømmelser)
1.5