IF Statement combined with RoundUp

[cgray467]

Good morning,

I am trying to nest RoundUp Statement within an IF statement for a decimal place.


For example if the value is 20.30 I would like it to read 20. If it is 20.50 it can remain the same.


Your help is much appreciated.

 

[Special-K99]

20.30 to 20 is rounding down not up.

Maybe

=A1-(MOD(A1,1)<0.5)*MOD(A1,1)

or

=IF(MOD(A1,1)<0.5,INT(A1),A1)

 

[Fluff]

Hi & welcome to MrExcel.
Along with Special-K99 comment, what should be the result for
20.60
20.80