เสร็จสมบูรณ์

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)

ทักษะ: Excel

ดูเพิ่มเติม : need help adding google adsense site, need help adding friends myspace outsource, i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i need help advertising my website, i need help designing a form, i need help designing a shirt, i need help designing clothes, i need help designing my van wrap, i need help find worker, i need help finding a manufacturer, i need help finding a shoes designer, i need help from an engineer, i need help from scientist, i need help getting my book edited not much money, i need help in designing a powerpoint presentation for a conference, i need help in getting leads to sell my service, i need help in writing a think piece, i need help in writing an executive summary, names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i need help with excel

เกี่ยวกับนายจ้าง:
( 0 บทวิจารณ์ ) Tampa, United States

หมายเลขโปรเจค: #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 ใน 1 วัน
(351 บทวิจารณ์)
7.4

freelancer 18 คน กำลังเสนอราคาเฉลี่ยที่ $67 สำหรับงานนี้

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 เพิ่มเติม

$50 USD ใน 3 วัน
(31 บทวิจารณ์)
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 ใน 1 วัน
(57 บทวิจารณ์)
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 เพิ่มเติม

$47 USD ใน 1 วัน
(23 บทวิจารณ์)
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 ใน 1 วัน
(9 บทวิจารณ์)
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 เพิ่มเติม

$35 USD ใน 1 วัน
(2 บทวิจารณ์)
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 ใน 1 วัน
(3 บทวิจารณ์)
1.2
hiteshchavadaa

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 เพิ่มเติม

$35 USD ใน 1 วัน
(1 บทวิจารณ์)
1.0
$156 USD ใน 3 วัน
(0 บทวิจารณ์)
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 ใน 7 วัน
(0 บทวิจารณ์)
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 ใน 2 วัน
(0 บทวิจารณ์)
0.0
saidalijan

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

$80 USD ใน 7 วัน
(0 บทวิจารณ์)
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 ใน 1 วัน
(0 บทวิจารณ์)
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 ใน 2 วัน
(0 บทวิจารณ์)
0.0
Arsadmansoori12

Sir I will give complete your work

$30 USD ใน 2 วัน
(0 บทวิจารณ์)
0.0
bautistajoyceann

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

$156 USD ใน 3 วัน
(0 บทวิจารณ์)
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 เพิ่มเติม

$30 USD ใน 1 วัน
(0 บทวิจารณ์)
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 ใน 7 วัน
(0 บทวิจารณ์)
0.0