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

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

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

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.

"Help in Excel" <Help in wrote in message
...
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