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
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