Need formula

[RoofCo]

We need a round up formula to round three values only:

.01 to <.32= .33
.34 to <.65= .66
.67 to <.99= 0

Can this be done, if so how?

Thanks

 

[JE McGimpsey]

One way:

=FLOOR(CEILING(E1,1/3),0.01)

We need a round up formula to round three values only:
Can this be done, if so how?

Thanks

 

[bpeltzer]

I'd create a table that indicated the 'breakpoints' the define each range,
and the appropriate treatment for that range. In c1:d4, my table is:
0 0
0.001 0.33
0.331 0.66
0.661 1
(This would take a value >=0.001 but <0.331 and convert it to 0.33, for
example)

Then with the values in column A, my formula in B1 is
=TRUNC(A1)+VLOOKUP(A1-TRUNC(A1),C$1$4,2,TRUE).

 

[Ron Coderre]

Here you go...I believe this works:

For a column of values beginning in A1, put this formula in anywhere in row
1 and copy down:

=MOD(INT(CEILING(A1,1/3)*100)/100,1)

Does that help?