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