Tag Archives: ABS

How To Change Number Signs Using Formulas

Today I’m going to have a look at three questions which crop up time and time again on the online forums. The answers are very simple when you know how, so they should be part of every Excel user’s tool … Continue reading

Posted in Microsoft Excel | Tagged , , | 2 Comments

Calculate The Absolute Sum in Excel

A colleague of mine asked me today how to go about using MS Excel formulas to calculate the sum of absolute values from a given dataset. This question crops up quite often on the forums so I thought I’d put together a quick blog … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , | 2 Comments