Decimal?

[LD]

Hi all.

I need help with a formula.
I want to roundup if a value's decimal is greater than .7
and rounddown if less.

How do I get the value of the decimal?

 

[Harald Staff]

Hi

One way
=INT(A1)+(MOD(A1,1)>=0.7)
You don't spesify desired behavior on exact .7 .Here it rounds up. Remove
the last equal sign to round down instead.

 

[Paul]

Hi all.

I need help with a formula.
I want to roundup if a value's decimal is greater than .7
and rounddown if less.

How do I get the value of the decimal?

One way is to subtract 0.2 from the number and then round as normal:
=ROUND(A1-0.2,0)