DanielReam
3 years agoQrew Member
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</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
------------------------------
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
------------------------------