Thread: I would like a function to return a value that fits its range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default I would like a function to return a value that fits its range
One way:

=LOOKUP(A1,{0,501,1001},{0.20,0.15,0.125}) with cell formatted as %

or look at VLOOKUP function

"rpbsr" wrote:

For example:
0-$500 = 20%
501-$1000 = 15%
1001-$5000 = 12.5%

Thank you!
Reply With QuoteReply With Quote