Ads

Tuesday, 17 January 2017

ABS()

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