Cantonalives
Member
Hi all,
Essentially I need a formula to use in Powerpivot and I am struggling a bit.
Basically if a number if over a certain decimal, say .5 then leave the number as is, however if its lower than .5 then rounddown.
For instance
C12 = 18.5 then this is 18.5
C12 = 18.4 then this would be 18
Seems so simple but the decimal aspect is catching me out at the moment.
Thanks for any assistance..
-CL.
Essentially I need a formula to use in Powerpivot and I am struggling a bit.
Basically if a number if over a certain decimal, say .5 then leave the number as is, however if its lower than .5 then rounddown.
For instance
C12 = 18.5 then this is 18.5
C12 = 18.4 then this would be 18
Seems so simple but the decimal aspect is catching me out at the moment.
Thanks for any assistance..
-CL.