View Single Post
 
Old 06-30-2021, 12:59 AM
jocotan88 jocotan88 is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2021
Posts: 2
jocotan88 is on a distinguished road
Default IF statement for numeric picture switch

Good day,

I have trouble getting this formula to work,

{IF {MERGEFIELD ABC}<1 "/#0.000" "/#0.00"}

I require the value to be displayed in 3 decimal places if it is below 1 and 2 decimal places if it is equal or above 1.

Thank you in advance!
Reply With Quote