PDA

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



cbs81
03-28-2007, 11:47 PM
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
03-28-2007, 11:58 PM
There's probably other (and more elegant) solutions for this, but off the top of my head one solution is:

=INT(A1*100)/100

xld
03-29-2007, 01:38 AM
=ROUNDDOWN(A1*0.333,2)

xld
03-29-2007, 01:42 AM
You could also use

=TRUNC(A1*0.333,2)

geekgirlau
03-29-2007, 02:12 AM
Nice one xld!