# Excel VBA Logical Functions With GOTO Lines to Seperate

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

Tietoa työnantajasta:
( 0 arvostelua ) Dudley, United Kingdom

Projektin tunnus: #16097158

## 1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön

insidenetsoft

Hired by the Employer

£150 GBP 3 päivässä
(26 arvostelua)
4.4