Dropping off all characters after .xx decimal place (not rounding up or down)

[cbs81]

Hi all,

I got a small tricky question for you all..

I have a row of data in column A:

eg

185.60214.40225.00235.20244.40


in column B, I want to multiply this by .333

I then end up with these amounts in column B:

61.804861.86666771.4666677578.4


The challenging question is, I want to Completely DROP the characters after the decimal .XX so New figures will be reported with no reference to previous figures. The new output should be now:

61.80
61.86
71.46
75
78.4

Note this is NOT a rounding off function to a higher or lower number, Its a complete Drop off anything after .XX

How do we do this so that say if you want to multiply 61.80 x 5 it would equal 309 and NOT multiply the backing figure of 61.8048 x 5 to give a slightly different figure..

How do we do this???

Thankyou sooooo much in advance for all your help

[geekgirlau]

There's probably other (and more elegant) solutions for this, but off the top of my head one solution is:

=INT(A1*100)/100

[Bob Phillips]

=ROUNDDOWN(A1*0.333,2)

[Bob Phillips]

You could also use

=TRUNC(A1*0.333,2)

[geekgirlau]

Nice one xld!