View Single Post
 
Old 06-03-2014, 01:35 PM
ScottA ScottA is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default

bigukfan -

Give this a shot... Works for me in my document anyway. Had to read between the lines a bit so hope I interpreted what you need correctly.

Assuming that you want to format all values as 2 digit decimal - Then
to bold any LVMass value that is less than 200.

{if {condition } < 200 {true_result} {false_result}}

The formula would be:



{if {MERGEFIELD LVMass} < 200 {MERGEFIELD LVMass \# "0.00"} {MERGEFIELD LVMass \# "0.00"}}

Note that you have to put the picture switch in for both the true and false
results to have all the values display with decimals. Also note that you have to insert the curly brackets - {} - using CTRL-F9 key combination. You can't just type them in.

The bold formatting was applied after the whole formula was input using the bold key (CTRL-b)

Hope that is what you needed!

Scott

Last edited by ScottA; 06-03-2014 at 05:39 PM.
Reply With Quote