Decimal?

  • Thread starter Thread starter LD
  • Start date Start date
L

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?
 
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.
 
LD said:
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?
Click to expand...

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