View Single Post
  #1   Report Post  
Duncan Help
 
Posts: n/a
Default An in between lookup function

I am looking for a function that will allow me to compare a sales number to
lower column 1 and upper column 2, and return to me a percentage that's in
column 3. This will be used for commision percentage depending on $'s of
sales.