PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-ABS

INTRODUCTION

ABS function comes under the MATH AND TRIG category in Excel.

ABS function returns the absolute value of any real number. Absolute value ignores the sign of the number and returns the positive number only.

ABS function can be used for a case where we need to ignore the sign of the number.

          

 

PURPOSE OF ABS FUNCTION IN EXCEL

Returns the absolute value of a number. The absolute value of a number is the number without its sign

 

PREREQUISITES TO LEARN ABS

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: ABS FUNCTION

The Syntax for the function is

=ABS(NUMBER)

NUMBER Real number of which we need the absolute value for.

 

 

EXAMPLE:ABS FUNCTION IN EXCEL

DATA SAMPLE

Let us take few samples with positive and negative signs and try to find out the absolute values for all the
samples.

 

EXCEL FUNCTION ABS
EXCEL:ABS FUNCTION ANIMATED EXAMPLE

STEPS TO USE ABS FUNCTION

The different values are put in E8 to E10.

Few are without negative symbol and few with symbol.

The function is put in F9 F10 AND F11.

=ABS(E8)

SIMILARLY  for other two cells.

The absolute values are shown in the picture.


OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: