Thread: [Solved] Rounding of dollar value
View Single Post
 
Old 07-05-2022, 01:48 PM
Formd Formd is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Feb 2015
Location: TX
Posts: 46
Formd is on a distinguished road
Default Rounding of dollar value

I did some research but did not find a solution, so I am coming to the experts.
I need to round off a dollar value to the nearest dollar amount with a mergefield. Example if my figures show 549.36 (.49 or less) then my value should merge 549.00. If it is .50 or higher, then the dollar value would merge 550.00
I tried { MERGEFIELD Debt \#$,0.00} but it did not round of the dollar value.
Reply With Quote