View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IF function incompetent[_2_] IF function incompetent[_2_] is offline
external usenet poster
 
Posts: 18
Default IF formula help part two

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