Purpose:
Suppose for counting purpose, you want only the absolute value i.e. without any sign ( + / - ), then this is the function that you must be looking at.
Command:
=ABS(number)
Example:
Enter following data into Excel:
Now select cell A4 & add following formula:
=A1+A2+A3
This will return you a value of -16
Now check what happens when you use ABS function:
=ABS(A1)+A2+ABS(A3)
Check the value now, it is 34
I haven't come across any particular application for this function, but never know when this might be required
See below image:
Suppose for counting purpose, you want only the absolute value i.e. without any sign ( + / - ), then this is the function that you must be looking at.
Command:
=ABS(number)
Example:
Enter following data into Excel:
| A1: -23 |
| A2: 9 |
| A3: -2 |
Now select cell A4 & add following formula:
=A1+A2+A3
This will return you a value of -16
Now check what happens when you use ABS function:
=ABS(A1)+A2+ABS(A3)
Check the value now, it is 34
I haven't come across any particular application for this function, but never know when this might be required
See below image:
No comments:
Post a Comment
Thanks for your time!