Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2021, 12:59 AM
jocotan88 jocotan88 is offline IF statement for numeric picture switch Windows 10 IF statement for numeric picture switch Office 2019
Novice
IF statement for numeric picture switch
 
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
  #2  
Old 06-30-2021, 06:40 PM
jocotan88 jocotan88 is offline IF statement for numeric picture switch Windows 10 IF statement for numeric picture switch Office 2019
Novice
IF statement for numeric picture switch
 
Join Date: Jun 2021
Posts: 2
jocotan88 is on a distinguished road
Default

Formula should be:

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

However i still am not able to get it to work.
Reply With Quote
Reply

Thread Tools
Display Modes


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
IF statement for numeric picture switch 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
IF statement for numeric picture switch Date format switch with If statement sbarron76 Mail Merge 3 05-03-2013 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft