#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Formula should be:
{IF {MERGEFIELD ABC}<1 "\#0.000" "\#0.00"} However i still am not able to get it to work. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
how to format a picture switch in a merge field to only include the numbers in the middle? | becca | Mail Merge | 2 | 06-08-2016 01:15 PM |
Format Switch \* Caps won't work in if..then statement | cwright | Word | 2 | 03-27-2014 04:19 PM |
IF statement, AND & Vlookup on 3 condition that's not in numeric | JulieB | Excel | 15 | 01-10-2014 06:25 AM |
Date format switch with If statement | sbarron76 | Mail Merge | 3 | 05-03-2013 06:23 AM |