Solved

# Scoring

Posted on 2014-02-06
104 Views
Sir gowflow 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. Endsame way for LOW if you need detailed Step pls let me know I will post here.

Thanks
Scoring-G-V04.xlsm
0
Question by:itjockey
• 5
• 4

LVL 29

Expert Comment

All this should replace the previoous code or it is on top of the previous code ?
gowflow
0

LVL 29

Expert Comment

gowflow
0

LVL 8

Author Comment

0

LVL 8

Author Comment

it s your call, what ever you feel to do so? I just add one row Unity in Both High & Low process.

Thanks
0

LVL 29

Accepted Solution

gowflow earned 500 total points
try this
gowflow
Scoring-G-V05.xlsm
0

LVL 8

Author Closing Comment

Perfect
0

LVL 8

Author Comment

May I Post My Next Question?

Thanks
0

LVL 29

Expert Comment

yes
0

LVL 8

Author Comment

here it is Scoring.

Thanks
0

## Featured Post

This collection of functions covers all the normal rounding methods of just about any numeric value.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.