View Single Post
  #1   Report Post  
Michael NYC
 
Posts: n/a
Default return a value based on a range

I want to return a value (a number) based on a number in anotehr cell that is
within a range of numbers using the IF function. For example: A2=$75 if B2=5,
A2=$100 if B2=10, A2=$150 if B2=15.

Can someone please give me the correct syntax, I am really lost!