maxima

[charijit]

I have

A1=2, A2=-3, A3=-55, A4=6, A5=9.

In A6 I wanted to put 1.1 times the maximum absolute value (55) with its sign (-55x1.1 = 60.5). For that I wrote

A6=LOOKUP(MAX(ABS(A1:A5)),ABS(A1:A5),SIGN(A1:A5))*ROUNDUP(1.1*MAX(ABS(A1:A5)),0).

The result of this formulae is #VALUE!. I wish to know my fault and also the method to achieve the desired result.

Wish you everyone MERRY CHRISTMAS.

 

[Domenic]

Hi, and Merry Christmas to you too!

Try the following...

=INDEX(A1:A5,MATCH(MAX(ABS(A1:A5)),ABS(A1:A5),0))*1.1

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

 

[Aladin Akyurek]

I have

A1=2, A2=-3, A3=-55, A4=6, A5=9.

In A6 I wanted to put 1.1 times the maximum absolute value (55) with its sign (-55x1.1 = 60.5). ...

Do you want to see 60.5 or -60.5 as result?

 

[charijit]

Aladin,
Sorry for the mistake. I wish to see -55*1.1 = -60.5 rounded up to -61.

 

[Aladin Akyurek]

Aladin,
Sorry for the mistake. I wish to see -55*1.1 = -60.5 rounded up to -61.

Wrap the formula expression Domenic suggested inside ROUND or ROUNDUP with decimal places set to 0.

 

[charijit]

Thanks to Domenic and Aladin

 

[ssywak]

w00t!

Man!

This is just the thing I was looking for!

Thanks, fellas!