Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Round down to nearest 5 cents in 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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Round down to nearest 5 cents in Word
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/show...?Number=365442 Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Brad Christie" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Round down to nearest 5 cents in Word
Thanks for that, and the # tip.
"macropod" wrote: 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/show...?Number=365442 Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Brad Christie" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mailmerge to show cents | Mailmerge | |||
Mail merge from Excel to Word, keeping $ and cents in text | Microsoft Word Help | |||
Rounding unit prices to the nearest unit | Microsoft Word Help | |||
Where is the currency symbol for cents? | Microsoft Word Help | |||
Where do I find the "cents" symbol ? | Microsoft Word Help |