Excel Hack

Absolute value in Excel shortcut

Absolute value is a value that represents the distance from the origin 0. For example, the absolute value of +3 is 3, but the absolute value of -3 is also 3. To find absolute value, you need to use the ABS function, but here we will learn how to use shortcuts to calculate absolute value instead of entering them manually. Note that some people confuse absolute value with absolute references, but they are not the same thing.

Shortcut to calculate absolute value

Windows
Access Key: Alt + M + G

Mac
None

Calculate absolute value using shortcut

For information on how to use shortcuts to calculate absolute value, see below.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell where you want the result of the absolute value calculation to be displayed. Remember the cell number (ex E2) that is the target of the absolute value calculation.

Open Math & Trig

Open Math & Trig

Press Alt + M + G to open Math & Trig; make sure ABS is selected.

Enter the cell number

Enter the cell number

Press Enter to display the Function Arguments dialog box. Enter the cell number that contains the number you want to make absolute (ex E2).

Absolute value calculation completed

Absolute value calculation completed

Press Enter. Absolute value have been calculated and reflected in the selected a cell.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments