excel 'mode' function w/ decimals

Hello. How can I convert my array of numbers with large decmials into integers or rounded decimals so that I can use the mode function?

Example:

cell array in A1, A2, A3 = { 1.1234, 1.1357, 2 }.
MODE(A1:A3) == N/A

conversion to -> { 1.1, 1.1, 2 }
MODE(A1:A3) == 1.1



tried doing round() for each cell, and
mode(round(a1,1):round(a3,1))

none of which work.

Thanks.

 

mode(round(a1:a3,1))

You were close. "Doing round() for each cell" - as in creating another array with rounded values outside of a1:a3, then taking mode of that array - also works, although must lose points for lack of parsimoniousness.

 

That seems to be it. Thanks for your reply.