View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
Posts: 271
Default if cell falls within range of number (i.e. 2500 to 4999)

I want to detetermine is a cell falls within a pre-estabished set up ranges.

Cell A1 = 4800
Such as
if quantity is 2500-4999 it should return 1.5%
if quantity is 5000-9999 it should return 1.2%

So this correct answer should return 1.5%