This formula helps to removes sign from number.
ABS(number)
Number= Select cell with number you this formula to work.
For example: When we pull expenses from ledger it shows as negative , but for Reporting purpose we want it to be positive. In this case we can use this formula.
No comments:
Post a Comment