Creating a Sign Max Function in Excel

's Computer Specifications

I am wondering how to create a formula in excel that will look at a
range of cells with positive and negative values and return the
largest magnitude while still keeping the sign. Here is an example of
what I am looking for....

500, 700, 900, -300, -500, -1100 ....... I want it to return -1100.

500, 700, 900, -300, -500, -100 ....... I want it to return 900.

Does anyone know how to accomplish this?

's Computer Specifications

On Feb 10, 11:31*am, Mike Weiler <m3wei...@gmail.com> wrote:
> I am wondering how to create a formula in excel that will
> look at a range of cells with positive and negative values
> and return the largest magnitude while still keeping the sign.

Since you want to retain the sign:

=IF(ABS(MIN(A1:A10))<ABS(MAX(A1:A10)),MAX(A1:A10),MIN(A1:A10))

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a Function in Excel 2003	Patti	Microsoft Excel Worksheet Functions	2	8th Sep 2009 07:24 PM
Help Creating a Function in Excel	kmatthews@mcsww.com	Microsoft Excel Misc	2	21st Jan 2007 07:35 PM
Creating an excel function	=?Utf-8?B?ZmlsbzY2Ng==?=	Microsoft Excel Programming	3	28th Apr 2005 01:15 PM
How do I define the signum function sign(x) in Excel?	=?Utf-8?B?Sm9uYXRoYW4=?=	Microsoft Excel Worksheet Functions	4	9th Nov 2004 02:36 PM
Creating a new sinus function in VBA Excel	Bogdan	Microsoft Excel Programming	0	11th May 2004 04:44 PM