Home » Forums » Open Source Learning Center » Question and Answer

Maximum Absolute value with same sign

Submitted by mrbhimani on 18 August, 2011 - 06:45

Dear Experts,

Please guide me on one simple query.

I need to get Maximum of two Absolute values with same sign (-ve/+ve).
Please see enclosed snapshot.

Query
‹ vlookup in excel 2007 Copy a range from excel to ppt as a bitmap ›
»
Almir's picture

Sign is good

Submitted by Almir on 23 October, 2012 - 22:39.

It is +, but not shown - that is convention.

»
Useful's picture

Try this Array Formula

Submitted by Useful on 31 August, 2011 - 08:16.

Hi

you may use this array formula (with Ctrl+Shift+Enter)

=IF(MAX(A1:B1)<MAX(ABS(A1:B1)),-MAX(ABS(A1:B1)),MAX(A1:B1))

have a nice day!

»
Vishesh's picture

Try this array formula. Set

Submitted by Vishesh on 18 August, 2011 - 07:26.

Try this array formula. Set the range accordingly.

=MAX(IF($A$7:$A$10<0,$A7:$A10))

»

Maximum Absolute value with same sign

Submitted by Anonymous on 18 August, 2011 - 10:09.

I DIDN'T GET YOUR POINT.

»
Vishesh's picture

This is an array formula...I

Submitted by Vishesh on 18 August, 2011 - 11:19.

This is an array formula...I forgot to mention. Enter that formula and press Shift+Ctrl+Enter

»