Naresh Patel
asked on
Scoring
Sir gowflow need little modification.
if C29=”High” then
+1 @ Cell B49 & D49 & F49 & H49
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
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
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
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
01.
On Button click analyzeif 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
file is password protected. pls remove the password
gowflow
gowflow
ASKER
ASKER
it s your call, what ever you feel to do so? I just add one row Unity in Both High & Low process.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect
ASKER
May I Post My Next Question?
Thanks
Thanks
yes
ASKER
gowflow