Excel Formula

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I want a formula please. I am using Excel 2011 and this can only have so many IF arguments in 1 cell.

If you have a look at the attached excel file, there are 2 columns and 2 boxes.

I want to be able to enter a value (Number) into D3 and return a value into F3.

The basic formula using the IF Function is

=((((IF(D3<=A2,B2,IF(D3<=A3,B3,IF(D3<=A4,B4)))) but I need to do this for each of the values and I can only repeat this function about 10 times in my version of Excel.

Excel

Project ID: #15070020

About the project

11 proposals Remote project Active 6 years ago

Awarded to:

rohitagarberg

hi sir, i have understood that you want to do a loookup for D3 based on range in A and output value in F3 for from B. I will do right now. thanks Relevant Skills and Experience excel Proposed Milestones $10 AUD - com More

$10 AUD in 1 day
(286 Reviews)
6.3

11 freelancers are bidding on average $19 for this job

semi786

Hi Sir/Mam, I am expert in advance excel. Please review my profile. My profile is suitable for this project. I can complete this project asap. Thank You, Semi786 Proposed Milestones $12 AUD - complete

$12 AUD in 0 days
(308 Reviews)
7.7
MimiFL

Creating a formula to find the correct bucket, currently you are using multiple ifs, but there is another way to accomplish the same thing which is much more elegant solution. Stay tuned, I'm still working on this pr More

$15 AUD in 0 days
(424 Reviews)
6.9
younus15

Hello. I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. Relevant Skills and Exper More

$35 AUD in 1 day
(86 Reviews)
5.6
awaisjahangir25

Text me brother, I can do this. Relevant Skills and Experience MS excel, Advance Formulas Proposed Milestones $20 AUD - a

$20 AUD in 1 day
(34 Reviews)
5.2
firozhossain606

Hi, I have the experience in working on different fields such as data entry, web research, web scrapping, product uploading, etc… Relevant Skills and Experience I am ready to do a free sample through which you can jud More

$15 AUD in 1 day
(4 Reviews)
2.0
androaiad

Hello dear, I can do your task in one hour ... Thanks Relevant Skills and Experience Expert in Excel Proposed Milestones $10 AUD - ..

$10 AUD in 1 day
(2 Reviews)
3.2
Shamimakther

Dear Sir, I have professional experience in Data entry. My data entries are 100% accurate. Also my typing speed is above 60wpm. With proficiency level, I am highly confident for your job. Thanks ! Relevant Skills and More

$25 AUD in 1 day
(0 Reviews)
0.0
ImronWahyudi08

A proposal has not yet been provided

$20 AUD in 3 days
(0 Reviews)
0.0