Reverse Signs for Values 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.