Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to format currency in a nested If statement?

Hi All!


I have tried for hours and can't figure this out.


For a field in my form I have an If statement:

If ( 'Form1'.Mode = FormMode.Edit , Text ( Parent.Default , "[$-en-US]$#,###" )  , varPrice2 )

This means If a gallery item is picked, the form will populate that items info in Edit Mode and if not, and a new form is created with a separate button, then varPrice2 will populate. This part works.


Now when I person selects the gallery item it is formatted in currency, when they go to change, say their prices however, the change does not format at all. How can I make the changed price format into currency using my above If statement? 


The formula I have for the OnChange property is for the varPrice2 which basically changes the live input to currency format in new formmode:



Thanks in advanced!


Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,582)