Skip to main content
Question

Using IF to compare values in two form fields

  • April 14, 2022
  • 0 replies
  • 154 views
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</font></b>",
"<font color=red><b>Values Do Not Match</font></b>")

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement