IF formula help part two

[IF function incompetent]

I am trying to do a similar thing but my values are different.

Can someone help me with this one??

 

[Ron Rosenfeld]

I am trying to do a similar thing but my values are different.


Can someone help me with this one??

IT will be easier to use VLOOKUP. Then you can set your values/equivalences to
whatever you want.
--ron

 

[Mike H]

possibly

=IF(J16<0,"",CHOOSE(MIN(J16+1,6),0,1.5,1.7,2,2.5,""))

Mike