Excel ABS Function

Use:
Computes absolute value of a single cell or numeric formula
Syntax:
ABS( cell )
Examples:
Cell E3 formula:     ABS( D3 )
Alternative E3 formula:     ABS( B3 + C3 )
Cell B7 formula:     ABS( SUM( B3:B6 ) )

Note:
ABS( cell ) is equivalent to IF( cell>=0 , cell , -cell )
Related Functions:
IF, MIN, MAX
Lotus 123 and Quattro Equivalent:
@ABS

button Home | Lectures | Handouts | Assignments | Exams | Grades | Odds & Ends

button This web site is maintained by John Mote for use by students in his MIS 311F class. Your comments and questions are more than welcome.