• Status: Solved
• Priority: Medium
• Security: Public
• Views: 166

# Scoring

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
Naresh Patel
• 10
• 5
1 Solution

Commented:
gowflow
0

0

if any clarification needed regarding process pls reply.

Thanks
0

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

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

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

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

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

Thanks
0

Commented:
Is this what you want ?
pls test it
gowflow
Scoring-G-V01.xlsm
0

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

Thanks You
0

May post part 2?

Thanks
0

Excellent
0

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

here it is Scoring.

Thanks
0

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Featured Post

• 10
• 5
Tackle projects and never again get stuck behind a technical roadblock.