IF formula help part two

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IF function incompetent - 12 Feb 2008 16:48 GMT

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

>>> The idea is that if J16 equals 0, then G11 will show 0
>>> If J16 is greater than 0 and less than 1, then G11 will show 0
>>> If J16 is equal to 1 but less than 2, then G11 will show 1.5
>>> If J16 is equal to 2 but less than 3, then G11 will show 1.75
>>> If J16 is equal to 3 but less than 4, then G11 will show 2
>>> If J16 is equal to 4 but less than 5, then G11 will show 2.5

Can someone help me with this one?? :(

Reply to this Message

Ron Rosenfeld - 12 Feb 2008 17:26 GMT

>I am trying to do a similar thing but my values are different.
>
[quoted text clipped - 6 lines]
>
>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

Reply to this Message

Mike H - 12 Feb 2008 18:01 GMT

possibly

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

Mike

> I am trying to do a similar thing but my values are different.
>
[quoted text clipped - 6 lines]
>
> Can someone help me with this one?? :(

Reply to this Message