On Tue, 12 Feb 2008 08:48:02 -0800, IF function incompetent
wrote:

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?? :(

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