![]()  | 
	
| 
	 | 
| 
		 
			 
			#1  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			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 |