Rounding IF statement?
try this...
=IF(MOD(A4,1)<0.1,ROUNDDOWN(A4,0),ROUNDUP(A4,0))
--
HTH...
Jim Thomlinson
"Matt" wrote:
Hello,
I'd like to setup a roundup or rounddown if statement stating:
If the value of A1 is x.1 to round up to the next whole number; ie (if A1 =
2.1 to round up to 3) but if A1 is x.0x to round down to the next whole
number; ie ( if A1 = 2.09 to round down to 2)
Is this at all possible?
TIA
|