Using IF to compare values in two form fields
I'm using a rich text - formula field to compare currency amounts in two form fields within the same form. So far this is what I have: IF([Amount 1]=[Amount 2], "<font color=green><b>Values Match...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry using the Round function.
Round( ...put your existing formula here, 0.01)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Round( ...put your existing formula here, 0.01)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
That did it thanks Mark