LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup & Lookup function error Beginner Excel Worksheet Functions 9 January 11th 05 12:37 AM
LOOKUP FUNCTION WITH SUMS ABILITY Jamesy Excel Discussion (Misc queries) 1 January 10th 05 03:39 PM
Lookup Function Ademar Excel Worksheet Functions 7 November 8th 04 11:50 PM
Vector lookup function GregTh Excel Worksheet Functions 1 November 4th 04 08:34 PM
Another Lookup function, please Butch Excel Worksheet Functions 3 November 3rd 04 08:52 AM


All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"