The ROUND function works like you thought it should; if I put 1.25 in A1 and
=ROUND(A1,1) in another cell, it reports 1.3 as the answer. So, I have to
conclude that you do not have 1.25 in your cell; rather, I suspect you are
adding values and have the totaling cell formatted to display 2 decimal
places. Then, if you had a total of, say, 1.249, it would display as 1.25,
but retains it actual value of 1.249 so that when you applied the ROUND
function, it would round down to 1.2 because the underlying value is really
less than 1.25. Does this by any chance describe your situation?

Rick


"the_superfly5" wrote in message
...
We have a time sheet program and for what ever reason it rounds down at
five
rather than up, like most of us are taught growing up. For example, if we
end
up with a time in decimal format of 1.25 hours. it rounds this time back
to
1.2. From 1.6 and above it rounds up. Now this being a time sheet the
actual
total time in decimal format will always be changing. I have the following
equation setup right now and it works. =IF(A1=1.25, RoundDown(A1, 1),
Round(A1, 1)). Of course right now this works only with 1.25. I need to
wildcard the "1.2" and leave the 5 for recognition. Can anyone help??
Thanks