How to find and return maximum or minimum absolute value and keep sign in Excel？

Описание к видео How to find and return maximum or minimum absolute value and keep sign in Excel？

In Excel, if there are some values in a column which both include positive and negative values, generally, you can find the maximum and minimum values of their absolute values by using the formula combines MAX and ABS functions. But in some times, you may want to find the maximum or minimum values of their absolute values but keep their sign. In this vedio, it introduces formulas and explain how to use to solve the job.
This vedio offers text version:
https://www.extendoffice.com/document...

Комментарии

Информация по комментариям в разработке

Похожие видео