Forum Discussion

Copper Contributor

Dec 22, 2018

round to the nearest number

HELLO , I want to round the number in cell D6 to the nearest number in raw (2) in the table (I:T,2:12). could you help me please, thank you.

Silver Contributor

Dec 22, 2018

Classic INDEX() with double MATCH().

=INDEX($J$4:$T$13,MATCH(E4,$I$4:$I$13,1),MATCH(D4,$J$2:$T$2,1))

Copper Contributor

Dec 22, 2018

it round to ( .15 ) which isn't in raw (2) in the table (I:T,2:12).