Forum Discussion
Solved
How to find the maximum deviation of a set of number that contain negative values
Here I am attached the worksheet
Comma is a style. You can modify this style to have 0 decimal places.
On the Home tab of the ribbon, click Cell Styles, then right-click Comma.
Select Modify..., then click Format...
Change Decimal places to 0, then cick OK.
This will apply to the active workbook only.
But you can create a new workbook, modify the Comma style as described, then save the workbook as an Excel template named Book.xltx in your startup folder for Excel - by default %appdata%\Microsoft\Excel\XLSTART. The name Book.xltx is obligatory (but it depends on the language).
It will then be used when you start Excel, and also when you create a new workbook by pressing Ctrl+N or by clicking New on the Quick Access Toolbar.
Instead of going through all that trouble with a formula, you could just use a box plot graph template that, at the click of a button, will identify your high and low deviations without having to convert your negative values to absolutes.