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
I have the same concern.
[Amount 1] is a manual input amount
[Amount 2] is a formula field using Query & Sum. Thinking it's something past the second decimal place. Have gone out as far as 10 decimal places but I'm not seeing anything obvious.
------------------------------
Daniel Ream
------------------------------
[Amount 1] is a manual input amount
[Amount 2] is a formula field using Query & Sum. Thinking it's something past the second decimal place. Have gone out as far as 10 decimal places but I'm not seeing anything obvious.
------------------------------
Daniel Ream
------------------------------
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