If function

05/11/21
Answered - Pending Review

Hello, may I request assistance troubleshooting a formula? I have the formula below to identify if the reconciliation is out of balance. In January, the Available Resources and Fiscal Report Ending Balance match, yet the Status display Out of Balance. Is it because it's a negative number?

=IF([Available Resources]@row = [Fiscal Report Ending Balance]@row, "Balance", IF([Available Resources]@row <> [Fiscal Report Ending Balance]@row, "Out of Balance"))


Popular Tags:

Answers

  • Leibel SLeibel S ✭✭✭✭

    @nskoulphong

    Is it possible they are off by decimals?

    You can correct this in the formula by adding the round function:

    =IF(ROUND([Available Resources]@row, 2) = ROUND([Fiscal Report Ending Balance]@row, 2), "Balance", IF(ROUND([Available Resources]@row, 2) <> ROUND([Fiscal Report Ending Balance]@row, 2), "Out of Balance"))

  • @Leibel S thank you for your reply. Perfect!

Sign In or Register to comment.