Excel Formula
$10-30 AUD
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.
Project ID: #15070020
About the project
Awarded to:
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
11 freelancers are bidding on average $19 for this job
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
Text me brother, I can do this. Relevant Skills and Experience MS excel, Advance Formulas Proposed Milestones $20 AUD - a
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
Hello dear, I can do your task in one hour ... Thanks Relevant Skills and Experience Expert in Excel Proposed Milestones $10 AUD - ..
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