C23 (Direct Input) should look up D6:D11
E23 (Direct Input) should look up E5:J5
Based on values in C23 and E23, the result should be in F23
Example 1: if C23 is $1500 and E23 is 150%, F23 should be 12.75% (G8)
Example 2: if C23 is $1350 and E23 is 124%, F23 should be 11.50% (E11)
Example 3: if C23 is $1650 and E23 is 230%, F23 should be 14% (J6)
Example 4: if C23 is $1540 and E23 is 210%, F23 should be 13.25% (I8)
D6:D11 and E5:J5 are set by "Payplan Parameters" table on the top right.
E24 should look up L13:L16
L13:M16 range is all Direct Input
Example 1: if E24 is 71%, F24 is 0.85% (M15)
Example 2: if E24 is 55%, F24 is 0% (outside lowest parameter in range?)
Example 3: if E24 is 75%, F24 is 1% (M16)
Example 4: if E24 is 70%, F24 is 0.60% (M14)
18 freelancers están ofertando el promedio de $67 para este trabajo
I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects Already done many excel projects. Check my feedback
Hi Sir, I read your job details carefully.I think I can better do the work with my experience knowledge and [login to view URL] to give the change to prove my [login to view URL] you.
I could help you out for the same. My expertise contain accounting, finance and microsoft office. Let me have the opportunity to provide the best i posses at the best market rate.