Sorry Pete

Here is what I am trying to do

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 you help me with this one?? :(

"Pete_UK" wrote:

I think you will need to give some more information (and details) than
just this.

Pete

On Feb 12, 4:20 pm, IF function incompetent <IF function
wrote:
I need to compare a range with a number and then have a certain result based
on the range. Can anyone help?