• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pls help me farmula calcution in this file

vletm

Excel Ninja
vishwasexcel
Based Forum Rules
... How Your thread title reflects with You thread? ... please, reread 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
 

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)

67744
 

Attachments

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
 
Top