If function

Nancy Skoulphong

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"))

Leibel 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

@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"))

Nancy Skoulphong

@Leibel S thank you for your reply. Perfect!