Rounding Question

[pokerwoody]

Hello,

I need a little help with rounding. I would like to round in .25 but would like to round closes to a reference value. example i am taking midpoint of 1.25 and 1.5 =1.375 if reference value is 1.25 or less i would like it to round to 1.25 if reference value is 1.5 or greater would like it to round to 1.5. if the values are 1.5 and 2 then it would just round to 1.75

thanks for reading.........

 

[Legacy 185660]

This may be a bit crude, as I am not THAT great with excel as some people here, but this should work (your number should be in A25, but you can change that easily)

=IF(RIGHT(A25,2)+0<=12.5,LEFT(A25,FIND(".",A25))&0,IF(RIGHT(A25,2)+0<=37.5,LEFT(A25,FIND(".",A25))&25,IF(RIGHT(A25,2)+0<=62.5,LEFT(A25,FIND(".",A25))&50,IF(RIGHT(A25,2)+0<=87.5,LEFT(A25,FIND(".",A25))&75,LEFT(A25,FIND(".",A25))+1))))+0

Make sure your cell is formatted to number

 

[Legacy 185660]

Actually use this code. This one will work if you put any number while the other would only work with 2 decimal places.

=IF(RIGHT(A21,LEN(A21)-FIND(".",A21)+1)+0<=0.125,LEFT(A21,FIND(".",A21))&0,IF(RIGHT(A21,LEN(A21)-FIND(".",A21)+1)+0<=0.375,LEFT(A21,FIND(".",A21))&25,IF(RIGHT(A21,LEN(A21)-FIND(".",A21)+1)+0<=0.625,LEFT(A21,FIND(".",A21))&50,IF(RIGHT(A21,LEN(A21)-FIND(".",A21)+1)+0<=0.875,LEFT(A21,FIND(".",A21))&75,LEFT(A21,FIND(".",A21))+1))))+0

 

[pokerwoody]

Thanks.................