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.
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.