En cours

Lookup formule -- 2

Looking for a solution for the following excel formula:

Cel C23 should show the result of the criterium "if result is bigger then 20, C23 should show B23. But the formula should have multiple criteria as in: If B23 is bigger then 20 then show result B20 in C23, but if result is bigger then 30 show result C20 in C23, but if results is bigger then 40 show result D20, but if bigger then 50 then show result E20, but if bigger then 60 show result F20, but if bigger then 70 show result G20

Op zoek naar een eerder eenvoudige excel formule:

Cel 23 moet het resultaat weergeven dat gebonden is aan het criterium groter dan X. X is een variabel die indien groter dan 20 het resultaat uit tabel B20 moet ophalen, indien groter dan 30 uit tabel C20, indien groter dan 40 uit tabel D20, indien groter dan 50 uit tabel E20, indien groter dan 60 uit tabel F20, indien groter dan 70 uit tabel G20

Compétences : Excel

Voir plus : looking develop ss7 hlr lookup, zijn wij zoek naar een schrijver, shirt companies looking freelance artist, send form results sms, looking vice president sales, perl log mysql send results email, photoshop naar joomla, looking essay, looking english teacher, looking hire full time web designer 2008

Concernant l'employeur :
( 1 commentaire ) Amsterdam, Belgium

N° du projet : #8496430

Décerné à :

bossumd

Ready to do the job quickly and neatly. I'm able to start right now! The result will be in 10 minutes! MS Office 2003, 2007, 2011 (for MacOS), 2013. ---Updated I have solved your problem. Ik heb uw probleem hebben Plus

8 € EUR en 3 jours
(2 Commentaires)
1.2

14 freelancers are bidding on average €16 for this job

cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Plus

15 € EUR en 1 jour
(42 Commentaires)
5.9
slenders13

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Kind regards, Rens Slenders

20 € EUR en 1 jour
(5 Commentaires)
3.0
MohsanEijaz

I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the Plus

12 € EUR en 1 jour
(5 Commentaires)
2.4
KarrarRaza

Hi there. I can do this for you within an hour. Please respond if you want quick turnaround solution.

8 € EUR en 1 jour
(2 Commentaires)
2.1
danilogbotelho

Hi! I'm available right now for this. This is a simple task that I can do right away. Best regards, Danilo.

8 € EUR en 0 jours
(1 Commentaire)
0.6
Stevewh

Hi, i am so good with excel I can do it fast now (today) , just request me in the chat window Thanks

23 € EUR en 1 jour
(1 Commentaire)
0.8
prateekbatra32

Hi, I'm a chartered accountant (CPA equivalent) with 5 years of experience in finance and MS office. I can help you in creating this excel formula that would pick up the desired number basis the values in the target ce Plus

12 € EUR en 1 jour
(1 Commentaire)
0.4
jaymohonline

Hi, I have seen the job you posted and I fully understand your task requirements, and can achieve your objective. I have extensive skills in microsoft office Am looking forward to discussing more details with you. Th Plus

23 € EUR en 1 jour
(0 Commentaires)
0.0
MoohHHooM

i have a very good experience in excel and its formulas. i am also a vba developer so maybe i can create a script for you

14 € EUR en 0 jours
(0 Commentaires)
0.0
advinta

A proposal has not yet been provided

24 € EUR en 1 jour
(0 Commentaires)
0.0
waeemasghar9

A proposal has not yet been provided

23 € EUR en 1 jour
(0 Commentaires)
0.0
oscarae

Dear Requestor, Heb even gekeken naar de beschrijving en je voorbeeld, het is enigszins verwarrend. Denk dat we daar wel samen uitkomen. Oplossing zal in de richting liggen van: als(en(variabele>20,variabele< Plus

14 € EUR en 1 jour
(0 Commentaires)
0.0
asifmd28

Excellent excel skills. Have 8+years of experience in excel. Built many projects. automated many reports.

23 € EUR en 1 jour
(0 Commentaires)
0.0