# maxima

#### charijit

##### Board Regular
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.

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

#### Domenic

##### MrExcel MVP
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!

##### MrExcel MVP
charijit said:
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

##### Board Regular
Sorry for the mistake. I wish to see -55*1.1 = -60.5 rounded up to -61.

##### MrExcel MVP

charijit said:
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.

#### ssywak

##### New Member
w00t!

Man!

This is just the thing I was looking for!

Thanks, fellas!

Replies
1
Views
78
Replies
13
Views
173
Replies
2
Views
193
Replies
3
Views
95
Replies
4
Views
126