Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Reverse Signs on Jet Function Results


Overview

Often times when building financial statements, the sign needs to be reversed in the report.

Use a negative sign before the GL(), NL(), of NF() functions to reverse the sign rather than multiplying by -1.

=-@GL("Balance",....)
=-@NL("Sum",....)
=-@NF($D4,....)

It creates a more efficient report to reverse a sign using Excel formatting rather than performing math on a Jet function.

Was this article helpful?
1 out of 1 found this helpful

Comments