Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Scoring

Posted on 2014-02-05
Medium Priority
155 Views
Hi Experts,

I need to following steps in my WB via VBA.

## 01.

On Button click analyze
if C29=”High” then
+1 @ Cell B48 & D48 & F48 & H48

## 02.

Find C22 Value from Range C2:C10 (+ or – 3 point leverage)
if True then find respective factor in range B39:B47 & Add +1 else nothing next step

## 03.

Find C23 Value in Range C2:C10(+ or – 3 point leverage)
if true then find respective factor in range D39:D47 & Add +1else nothing next step

## 04.

Find C22 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range F39:F47 & Add +1 else nothing next step

## 05.

Find C23 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range H39:H47 & Add +1 else nothing. End
Find attached file

Thanks
Scoring-G.xlsm
0
Question by:Naresh Patel
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 10
• 5

LVL 31

Expert Comment

ID: 39836469
gowflow
0

LVL 8

Author Comment

ID: 39836485
0

LVL 8

Author Comment

ID: 39836520
if any clarification needed regarding process pls reply.

Thanks
0

LVL 31

Expert Comment

ID: 39836549
yes step 1 we add 1 to existing ?
step 2,3,4,5 where we add 1 what column
gowflow
0

LVL 8

Author Comment

ID: 39836610
ok
yes step 1 we add 1 to existing ?
Yes if there is "" then 1 if there is 3 then add +1 = 4
step 2,3,4,5 where we add 1 what column
ok
first change leverage (+ or – 3 point to 4 points) just for understanding
In Step 4  we found in TRUE value in cell G6 which is 288 & Cell C22 is 284 so assuming 4 point leverage comes to 284+4= 288. Factor for G6 is -180. So we have to put +1 in Cell F43. I guess you understand what am I up to.

Thanks
0

LVL 8

Author Comment

ID: 39836631
This is Stage 1 of this question. there 2 more. second one  for LOWS & last for applying to all data point Math G

Thanks
0

LVL 31

Expert Comment

ID: 39836897
would you simply wait till one finishes part 1 so you post part 2 ?? why this rush ??
gowflow
0

LVL 8

Author Comment

ID: 39836953
I am just saying Sir I am not gona post before Part one is over.

Thanks
0

LVL 31

Accepted Solution

gowflow earned 2000 total points
ID: 39836973
Is this what you want ?
pls test it
gowflow
Scoring-G-V01.xlsm
0

LVL 8

Author Comment

ID: 39837001
Yes Sir    :) only confirmation from your side leverage factor is + or - 4 point. m I right?

Thanks You
0

LVL 8

Author Comment

ID: 39837015
May post part 2?

Thanks
0

LVL 8

Author Closing Comment

ID: 39837104
Excellent
0

LVL 31

Expert Comment

ID: 39837143
yes go ahead although it is 11:30 now will try my best
gowflow
0

LVL 8

Author Comment

ID: 39837150
here it is Scoring.

Thanks
0

LVL 8

Author Comment

ID: 39839192
My Bad Sir Need little modification.

## 01.

On Button click analyze
if C29=”High” then
+1 @ Cell B49 & D49 & F49 & H49

## 02.

Find C22 Value from Range C2:C11 (+ or – 3 point leverage)
if True then find respective factor in range B39:B48 & Add +1 (if  it is at Close Hits then put +1 @ Unity)else nothing next step

## 03.

Find C23 Value in Range C2:C11(+ or – 3 point leverage)
if true then find respective factor in range D39:D48 & Add +1(if  it is at Close Hits then put +1 @ Unity )else nothing next step

## 04.

Find C22 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range F39:F48 & Add +1 (if  it is at Point Hits then put +1 @ Unity )else nothing next step

## 05.

Find C23 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range H39:H48 & Add +1 (if  it is at Point Hits then put +1 @ Unity )else nothing. End
same way for LOW if you need detailed Step pls let me know I will post on that question.

Thanks
Scoring-G-V04.xlsm
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month6 days, 21 hours left to enroll