Thread: Finding a Value Between Two Numbers and Returning Corresponding Value
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default Finding a Value Between Two Numbers and Returning Corresponding Value
On Aug 19, 7:46*pm, Pete_UK wrote:
Hi Don,

that's what the OP asked for.

Pete

On Aug 19, 10:10*pm, Don Guillett wrote:





If you ask for 12 with this formula you will get the higher figure- Hide quoted text -

- Show quoted text -

I MEANT (getting old) if the OP asked for 13 they would NOT get 13 but
would get 20
Reply With QuoteReply With Quote