# I need help with adding functionality in Excel spreadsheet

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)

( 0 comentarios ) Tampa, United States

Nº del proyecto: #24615374

P0L

Hello, I am an Excel expert and I would like to help you with your formulas. Please check my profile and contact me to discuss further details. Regards.

\$50 USD en 1 día
(351 comentarios)
7.4

## 18 freelancers están ofertando el promedio de \$67 para este trabajo

finecodervw

Hi, Keen to work on this project. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, Countif, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional fo Más

\$50 USD en 3 días
(31 comentarios)
5.2
Orientwork

hello sir.... how are you... i can start this job right now... i have lot of experince about this task.. please talk to me...thanks & regards

\$50 USD en 1 día
(57 comentarios)
5.1
ravinderkumar248

Hi there, I read your project description carefully, and would like to help you in your project. I am excel cva expert and have 8 years of experience in creating complex automations, database, query, Macros. can Más

\$47 USD en 1 día
(23 comentarios)
4.6
dataEntryExperty

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

\$30 USD en 1 día
(9 comentarios)
2.8
jnpkfb

Hi there, I checked attachment and understood the excel structure. I am an Expert in Ms excel (15 years) I have no project in my hand so that I can start your project right now. I guarantee 100% accuracy. If you aw Más

\$35 USD en 1 día
(2 comentarios)
1.2
chenshan91

Hello. I saw your xls file. I can provide you excellent file. High quality and low cost. I am waiting for your reply. Thanks. Regards.

\$30 USD en 1 día
(3 comentarios)
1.2

Hi there, Vlookup master How Much Work ??? Message Me Now... Start Immediately, Professional Expert, Check Review. I am interested in doing your work. i have read and understand your project description and also req Más

\$35 USD en 1 día
(1 comentario)
1.0
\$156 USD en 3 días
(0 comentarios)
0.0
sabbirulhabib

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.

\$67 USD en 7 días
(0 comentarios)
0.0
sharmaviivek86

sir i am very good at excel please provide this job to me, i will try to get this job done before committed time Speed is the key with accuracy

\$35 USD en 2 días
(0 comentarios)
0.0
saidalijan

All done contact me. ............................. ........................................................

\$80 USD en 7 días
(0 comentarios)
0.0
nabin2069

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.

\$50 USD en 1 día
(0 comentarios)
0.0
bwijaya2

Hello Sir/Madam, I have many years of experience in exercising spreadsheet data, including advanced formula. You can count me in.

\$140 USD en 2 días
(0 comentarios)
0.0

Sir I will give complete your work

\$30 USD en 2 días
(0 comentarios)
0.0
bautistajoyceann

Hi im joyce' i know that your busy for other work load, let me help you for this.

\$156 USD en 3 días
(0 comentarios)
0.0
RAHEEQMOHAMMED

I am a professional in using Excel ... Get the highest quality and lowest price with me. I can start working now and I will work for you completely until the completion of the project ... I will be happy to work with y Más

\$30 USD en 1 día
(0 comentarios)
0.0
GMEPRAL

i am interested in your project i assure you to complete this with in stipulated time, and in quality manner

\$140 USD en 7 días
(0 comentarios)
0.0