find value which is greater than in a range of cells and return the greater value

1. find value which is greater than in a range of cells and return the greater value

hi freinds,

i have a problem, i am new to excel formulas i want to find value which is next higher than d13 cell value in a range d3:d8 and return the higher value to a cell

this will be helpful for me if you solve the problem thanks in advance

thanking you

green

Calc.xlsx

2. Re: find value which is greater than in a range of cells and return the greater value

See if this is what you want?
=INDEX(\$D\$3:\$D\$8,MATCH(\$D\$13,\$D\$3:\$D\$8,-1))

3. Re: find value which is greater than in a range of cells and return the greater value

hi

Fdibbins

ihave seen your reply and used the formula how i can edit the formula to use for other cell values that is d14, d15,d16 ..........etc

4. Re: find value which is greater than in a range of cells and return the greater value

Not sure what you mean? Something like this?

=INDEX(\$D\$3:\$D\$8,MATCH(\$D13,\$D\$3:\$D\$8,-1))

There are currently 1 users browsing this thread. (0 members and 1 guests)