Round down to nearest 5 cents in Word

[Guest]

Hi

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]

Hi Brad,

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

 

[Guest]

Thanks for that, and the # tip.

Hi Brad,

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

Hi

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