# Pls help me farmula calcution in this file

Dear All Masters

#### Attachments

• 15.2 KB Views: 5

#### Marc L

##### Excel Ninja
Difficult to help without explanation & attachment, both smart enough …​

#### vletm

##### Excel Ninja
vishwasexcel
Based Forum Rules
... is there any clear rules - how to figure?

#### vishwasexcel

##### New Member
please open file I have marked in yellow color column's figure in calculate green color (incentive earn ) columns the file where I need auto calculated data

#### vishwasexcel

##### New Member
vishwasexcel
Based Forum Rules
... is there any clear rules - how to figure?
Thank you..

#### vletm

##### Excel Ninja
vishwasexcel
Thank You is many times okay,

#### GraH - Guido

##### Well-Known Member
PANG!!! A shot in the dark, most likely the bullet is traveling in the opposite direction.

#### Attachments

• 15.7 KB Views: 5

#### bosco_yip

##### Excel Ninja
Another shot in the dark...….

1] In C34, copied across and down :
=IF(\$B34="","",ROUND(MIN(MAX(VLOOKUP(\$B34,\$Q\$7:\$T\$10,3,0),VLOOKUP(\$B34,\$B\$23:\$N\$29,COLUMN(B1),0)),VLOOKUP(\$B34,\$Q\$7:\$T\$10,4,0))*VLOOKUP(\$B34,\$Q\$7:\$T\$10,2,0),0))

2] In C42, copied across :
=SUM(C34:C41)

3] In C43, copied across :
=VLOOKUP(C42,\$C\$51:\$D\$73,2,0)

#### Attachments

• 16.4 KB Views: 6

#### vishwasexcel

##### New Member
Another shot in the dark...….

1] In C34, copied across and down :
=IF(\$B34="","",ROUND(MIN(MAX(VLOOKUP(\$B34,\$Q\$7:\$T\$10,3,0),VLOOKUP(\$B34,\$B\$23:\$N\$29,COLUMN(B1),0)),VLOOKUP(\$B34,\$Q\$7:\$T\$10,4,0))*VLOOKUP(\$B34,\$Q\$7:\$T\$10,2,0),0))

2] In C42, copied across :
=SUM(C34:C41)

3] In C43, copied across :
=VLOOKUP(C42,\$C\$51:\$D\$73,2,0)

View attachment 67744
thank you sir

vishwasexcel