How can i reduce precision only in the maximum value of a column matrix?

I would like to reduce the precision only to the maximum value of my matrix D3 (attached). All the values are with 4 decimals but i want the maximum with only two decimals, rounded down.

Thanks in advance

[madhan ravi]

madhan ravi:

format bank

Elisa Mammoliti:

but in that way i modify all the values of the matrix, i need to modify only the maximum value of this matrix and leave the others unmodified.

Answer 1

[Naman Bhaia]

Hey Elisa,

The max() function returns the maximum value in an array and its index position. So using the following command we get the maximum value of the array ‘slope1’ into the variable ‘a’ and its index position in variable ‘b’.

[a b] = max(slope1);

After finding the index position you can use the round() function to round off that particular value using the following command:

slope1(b)=round(slope1(b),2);