You are here

ABS(): EXCEL FUNCTION

ABS_FORMULA USE FOR:

THIS FUNCTION IS USE TO CHANGE ANY NEGATIVE VALUE TO POSITIVE VALUE. HERE YOU CAN VIEW THE ABS FORMULA IN MICROSOFT EXCEL 2007 WITH AN EXAMPLE THAT TO MAKE THE WAY EASIER….

EXAMPLE:

A1=-95
A2=ABS(A1)
OUTPUT=95

STEP BY STEP_ABS FUNCTION:

STEP 1

PUT A NEGATIVE VALUE IN ANY CELL

ABS_FUCTION_STEP_1
ABS_FUCTION_STEP_1

STEP 2

PUT THE FORMULA “=ABS(CELL NAME WHERE THE NEGATIVE VALUE IS)” EX:- =ABS(A1)

ABS_FUNCTION_STEP_2
ABS_FUNCTION_STEP_2

STEP 3

PRESS THE “ENTER” KEY

ABS_FUNCTION_STEP_3
ABS_FUNCTION_STEP_3

 

 

Leave a Reply

Top