Just have to add some math... (add 0.02 to your number and then take the

FLOOR, or conversely subtract 2 cents from your number and take the CEILING)

Given 2.34

Function = FLOOR(number,significance) = FLOOR (2.36,.05)

Result = 2.35

Given 2.31

Result = 2.30

Given 2.29

Result = 2.30

etc...

Dave

Quote:

>Try the CEILING or the FLOOR functions.

>Given 2.34

>Function =CEILING(number, significance) =CEILING(2.34, .05)

>Equals 2.35

>The only downside of this is that Ceiling always rounds up to the nearest

>significance...Floor rounds down.

>So that given "2.31" you'd get 2.35 as an answer with the Ceiling function.

>>On Tue, 22 Sep 1998 16:38:06 -0400, Karen Feigenbaum

>>>If you are trying to round the sum of A1:A3 to the nearest nickel, I

>>>would use:

>>>=ROUND(SUM(A1:A3),1)

>>For me, that rounds to the nearest dime.