Sep 25, 2023 04:28 AM - edited Sep 25, 2023 04:47 AM
Hello Everyone!
Can someone help me troubleshoot why using IF formula with arguments containing field values with decimal points return errors? All the fields are in currency format with precision of 1.00 except one with duration type field in seconds and in decimal format.
Here's my formula and there's at least 4 different results to expect (FULLY-PAID, PARTIALLY-PAID, OVER-PAID, NO PAYMENT and N/A if all 4 logical arguments are false. Below is my formula.
Sep 25, 2023 11:23 AM
This is probably because even though the fields are displaying to 2 decimal places, at least one of your numbers is being stored to more than 2 decimal places, so when comparing them they are not the same number. Try the round function:
...IF(ROUND({Total Amount Paid (ToDate)}, 2)=ROUND({Total Amount Due (ToDate)},2),"FULLY PAID",...