Rounding up help
 

I have a somewhat biased rounding up to perform, one decimal place. If the
value at the second decimal place is 5 or <5, increase or decrease value at
the first decimal place by 1. Ex., 3.36 to 3.4 and 3.34 to 3.3. When the
value is =5, the value should also be incresed by 1. Ex., 3.35 to 3.4. What
is the formula one should use?

Rounding up help
 

Try this:

=ROUND(A1,1)

Change A1 to match your cell reference.

HTH,
Elkar

"Kaputa" wrote:

I have a somewhat biased rounding up to perform, one decimal place. If the
value at the second decimal place is 5 or <5, increase or decrease value at
the first decimal place by 1. Ex., 3.36 to 3.4 and 3.34 to 3.3. When the
value is =5, the value should also be incresed by 1. Ex., 3.35 to 3.4. What
is the formula one should use?

Rounding up help
 

"Kaputa" wrote:
If the value at the second decimal place is 5 or <5,
increase or decrease value at the first decimal place
by 1. Ex., 3.36 to 3.4 and 3.34 to 3.3. When the
value is =5, the value should also be incresed by
1. Ex., 3.35 to 3.4. What is the formula one should use?

Does ROUND(value,1) do the trick for you? If not, why not?

Rounding up help
 

Does this do the trick for you
=IF(MOD(A18*100,10)=5,ROUNDUP(A18,1),ROUNDDOWN(A1 8,1))\
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Kaputa" wrote in message
...
I have a somewhat biased rounding up to perform, one decimal place. If the
value at the second decimal place is 5 or <5, increase or decrease value
at
the first decimal place by 1. Ex., 3.36 to 3.4 and 3.34 to 3.3. When the
value is =5, the value should also be incresed by 1. Ex., 3.35 to 3.4.
What
is the formula one should use?