how can I return a value in excel that looks at a range of number

H

Help in Excel

I have a range of numbers 1-10 and 10-20 each range will need to return a
separate number. Example if the value is 6 return $5.00 if it is 11 return
$4.00
 
G

Guest

Hi

What is the deciding factor as to what number is returned? You will either
need a table and a VLOOKUP function or maybe a nested IF.

Andy.
 
Top