This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these st...
This seems like ridiculously easy formula to write, but I’m stymied.
IF({Paid} ≥ {120%}, ({Paid} - FMV),0)
If the person Paid more than 120% (120% is a column calculating 120% of the Fair Market Value), then the value of their tax receipt is the amou...
Thank you, @ScottWorld. I was not an expert at Filemaker Pro either, but I did love it and had managed to make formulas work. That probably IS why I thought ≥ would work!
Filemaker was very expensive to upgrade, though, and it was hard for my busines...
I put the spaces in because some of the examples in the help seemed to have them. The extra { }s went in in desperation.
It’s definitely the ≥ symbol that was the problem. I never would have figured that out on my own.
Thanks again.
