How do I set a value greater or less than

D

Docwhitley

I am working on a spread sheet that will allow me to accurately keep track of
my commissions with the least amount of effort... and i am stuck on 1
formula... and I apologize if it is very basic but I am teaching myself this
software.

I want the sheet to look at the value of w5 and if it is between 20-24 I
want it to say 15 in w7 between 25 and 31 = 25 32 and 36 27.50

I hope that is enoungh information... if not let me know what else you need

Thanks
Will
 
T

Toppers

in W7:

=LOOKUP(W5,{20,25,32},{15,25,27.5})

add other values as required

The first set of data is lowest of your range e.g 20-24 =>20, 25-32=>25 etc.

These must be in ascending order.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function Greater than Less Than 2
Problem with formula for finding last greater than/less than or equal to value 2
Adding cells until they are greater than a lookup cell and returning a value 1
vlookup and match first value greater than 4
Need greater than = .. less than = combined with index/match state 8
Vlookup display value if greater than a number 0
Nested Greater than or less than Formula 4
COUNTIF greater than one column and less than another 5

Top