ABS will give absolute value of the number or formula.
Let say there are three values -5,-10 and - 8 in A1, B1 and C1 respectively.
=ABS(A1) will give 5
=ABS(A1*B1*C1) will give 400
Let say there are three values -5,-10 and - 8 in A1, B1 and C1 respectively.
=ABS(A1) will give 5
=ABS(A1*B1*C1) will give 400
ExpiresDefault access plus 1 year
Very nice information.
ReplyDeleteThank you for making such a positive difference. We truly appreciate you!
ReplyDeleteFreeze Panes: Keep headers DomaiNesia visible by selecting the row below and choosing View > Freeze Panes.
ReplyDelete