Using IF to compare values in two form fields

Question

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],
"Values Match",
"Values Do Not Match")

Currently even if the values match I'm getting the "Values Do Not Match" response.

What am I missing or what have I done wrong?

------------------------------
Daniel Ream
Builder
------------------------------

markshnier__you · Answer

The likely cause is that the values in fact do not match and your formula is correct.

Is it possible that these two fields are not identical in value right down to the last decimal place? Are these data entry fields or are they as a result of a calculation. If they are the result of a calculation I suggest using the Round function in their formulas to round them to 2 decimal places.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

danielream · Answer

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

markshnier__you · Answer

Try using the Round function.Round( ...put your existing formula here, 0.01)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

danielream · Answer

That did it thanks Mark

Forum Discussion

Using IF to compare values in two form fields

4 Replies