• 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

vishwasexcel
Based Forum Rules
... How Your thread title reflects with You thread? ... please, reread Forum Rules
... is there any clear rules - how to figure?
 
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
 
PANG!!! A shot in the dark, most likely the bullet is traveling in the opposite direction.
 

Attachments

  • Would_it_be_a_lookup.xlsx
    15.7 KB · Views: 5
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

  • MaxAndMinVlookup.xlsx
    16.4 KB · Views: 6
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
 
Back
Top