ROUND Formula

[dedwards]

Help! Is is possible to round a value on something other than .50.
want to round dollar values based on .35. Meaning if a price is $23.3
I want it to round to $24.00. If it is less than .35 I want it t
round down ($23.25 round to $23.00

 

[Frank Kabel]

Hi
one way:
=INT(A1)+(MOD(A1,1)>=0.35)

 

[Ron Rosenfeld]

Help! Is is possible to round a value on something other than .50. I
want to round dollar values based on .35. Meaning if a price is $23.35
I want it to round to $24.00. If it is less than .35 I want it to
round down ($23.25 round to $23.00)

How about: =ROUND(A1+0.15,0)


--ron

 

[Jonathan Cooper]

=IF((A1-INT(A1))<0.35,ROUNDDOWN(A1,0),ROUNDUP(A1,0))