Excel formula get value just greater than an other

0 votes

I was wondering how to retrieve the smallest value greater than an other one.

To my knowns :

Using an approximate match,VLOOKUP searches for the value X in column A, finds the largest value less than or equal to X in column A.

What would be the equivalent of VLOOKUP in order to find the smallest value greater than or equal to x

Example : In this table if my value is -0,322

enter image description here

VLOOKUP returns : -0,362

Which Formula would return :-0,317 ?

Apr 5 in Database by Edureka
• 9,700 points
31 views

1 answer to this question.

0 votes

We can use the Search function in Excel to find a value that equals a specified value, however it will return nothing if there are no values that exactly match the lookup value. Have you ever attempted to determine the closest value that is larger than or less than a certain amount, as shown in the screenshot below? In this tutorial, I'll show you how to use Excel formulas to get the closest number that is more or less than the lookup value.

doc closets value greater than 1

Locate the Lowest Price More than
Select a blank cell for the lookup result, type 
=MIN(IF(A1:B6>E1,A1:B6)) 

Hit  Shift + Ctrl + Enter at the same time. Take a look at this image:

doc closets value greater than 2

The range you want to locate value in is A1:B6, and the value you want to search for is E1.

answered Apr 5 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
111 views
0 votes
1 answer

Are there such things as variables within an Excel formula?

Yes. However, not directly. a less complicated method You ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
20 views
0 votes
1 answer

Insert a value to a cell in excel using formula in another cell

Select the cell where the formula should ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
52 views
0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,360 points
7,072 views
0 votes
1 answer
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 9,700 points
31 views
0 votes
1 answer

MS Excel - SumProduct formula with Loop

Drag this to the right of cell ...READ MORE

answered Mar 14 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
0 votes
1 answer

Excel formula for greater than but less than with several tiers

Use this: =MATCH(A1,{0,35,60,85,110}) READ MORE

answered Apr 5 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP