Round down to nearest 5 cents in Word
Brad Christie
Can anyone tell me the formula I can use in Word that will take the $ value
in on table field multiply it by a value in another field then round DOWN the
result to the nearest 5 cents.
I have this for the first part of the sum, just don't know how to round down.
=SUM(b1)*(c1) \# "$#,##0.00;($#,##0.00)
example: $165.69 x 0.7 = $115.983 ROUND to $115.95
macropod
Simple - code your field as:
{=INT(B1*C1*20)/20 \# "$,0.00;($,0.00)}
Note that I've deleted the '#' characters after the '$' signs - these force empty spaces to appear if the number is smaller than the
number of '#' characters, bit you don't need them for the ',' to work correctly.
For more information on field calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
"Brad Christie" <BradCh...@discussions.microsoft.com> wrote in message news:61D80C36-8FED-4787...@microsoft.com...