Create excel formula to calculate level of fitness

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

Hi, I need someone to create a formula that will fetch values from the table and the result would be written in words like on the table.

Take a look at the example in the image provided.

First you enter your bodyweight, then you enter your lift number.

After the formula needs to look up and see what the level it is and write it in level to the right.

It's all self explanatory in the image. I need to be able to input values in between levels too, and not the exact number on tables.

Also if you could write the level and the color that is the same as in the table it would be great.

Thanks.

Datainmatning Databehandling Excel

Projekt-id: #18758325

About the project

23 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please send me a message so that we can discuss more.

€30 EUR inom 1 dag
(307 omdömen)
7.3

23 frilansare har lagt bud på i genomsnitt €21 för det här jobbet

lightingdavid

Hello. How are you? I am highly interested to work on the "Create excel formula to calculate level of fitness". I am a full stack Excel expert. I have more than 7 years experience in "Data Entry, Data Processing, E Mer

€23 EUR inom 1 dag
(91 omdömen)
5.9
aminbros

.......................................................................................................................................................................

€34 EUR inom 1 dag
(12 omdömen)
5.2
Capitan0Trueno

The job is done. Try this formula in cell L5 of sheet "Freelancer contest": =OFFSET($A$4;0;MATCH($K$5;OFFSET($A$4;MATCH($J$5;$A$5:$A$23;1);1;1;5);1)) MS Excel advanced expert. 30 years experience in MS Excel Mer

€23 EUR inom 0 dagar
(36 omdömen)
5.0
awaisjahangir25

Hi, I got your requirement. I’ll share are really beautiful and professional looking template for said requirements Kindly let me know if you are interested. Regards

€14 EUR inom 1 dag
(37 omdömen)
5.3
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Mer

€29 EUR inom 1 dag
(32 omdömen)
4.9
Rina247

I have a team. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team

€23 EUR inom 1 dag
(38 omdömen)
4.6
pranthokumer

Hello there, I am highly interested to work on your "Create excel formula to calculate level of fitness" project. I have checked your attached file. I can do this with a good quality and with in your budg Mer

€10 EUR inom 1 dag
(22 omdömen)
4.0
shahinrahimi

I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ........ Mer

€10 EUR inom 0 dagar
(27 omdömen)
4.1
GabrielBarreiro1

Dear, I can make your excel workbook do what you need. I am available to start immediately, do not hesitate to contact me. Clarification: • The suggested delivery time is indicative. For a correct projectio Mer

€25 EUR inom 1 dag
(12 omdömen)
3.9
chraheelbhatti

I have seen details I will do it for you On The Go.

€9 EUR inom 1 dag
(9 omdömen)
3.8
Gajacrafty

Hai this is Gajendran, I’m having good experience in Data entry work. Based on your project description I will update formulas as per your requirement and provide you the best data, will complete this task within time Mer

€14 EUR inom 1 dag
(22 omdömen)
3.4
omachibrian5

I understand different excel features such as macros, formulations, cell referencing, vlookup among many other things. Given my experience I am in a position to assist you come up with acccurate answers on the weight c Mer

€29 EUR inom 1 dag
(5 omdömen)
2.9
MHaiciu

Hello! My name is Marian, and I can help with this job. I've been working with Excel in the last 15 years, and I can create a simple formula that does exactly what you need. I can start immediately, and I will a Mer

€15 EUR inom 1 dag
(13 omdömen)
3.1
writingspirit

I am a research writer with the experience is a number of fields. I am well versed with the research writing, the requirements and formats. I provide 100% original content and sound research.

€34 EUR inom 2 dagar
(5 omdömen)
2.9
DominikKrivarics

Hi Neighbor! I would be happy to help you with this spreadsheet. Thanks for the attached files! BR, Dominik

€24 EUR inom 1 dag
(5 omdömen)
2.6
pianesaup

I can try to do it.............................................................................................................................................................................................

€23 EUR inom 1 dag
(0 omdömen)
0.0
suvratjain2

Hi, I am proficient in excel and can do this project for you quite easily. I can give you the final deliverable in 2 hours for 30 eur. If this exceeds ypur budget, I can deliver the final deliverables tomorrow for 15 e Mer

€30 EUR inom 1 dag
(0 omdömen)
0.0
akmkz

Hi, I'm Alper, I can do it in Excel. But if you want to increase the budget a little more, and I can write a program. (30€)

€19 EUR inom 10 dagar
(0 omdömen)
0.0
marionavas

The target looks like very simple, data entered is Body Weight and kg Lifted, I can create a formula to check the table with Values en create an aproximate value to choose en the Result Cell the level (KG Lifted)

€14 EUR inom 1 dag
(0 omdömen)
0.0
AbdullahAltay

Hi, I can deliver your project in one day.....................................................................................

€23 EUR inom 1 dag
(0 omdömen)
0.0