ROUND rounds to a set number of decimals; ROUNDUP and ROUNDDOWN force direction; MROUND rounds to a multiple.
Do it with AI insteadRound to decimals
Use =ROUND(A2, 2) for two decimal places.
Always up or down
Use ROUNDUP or ROUNDDOWN with the same arguments.
Round to a multiple
Use =MROUND(A2, 5) to round to the nearest 5.
=ROUND(A2, 2)Formatting only changes the display; ROUND changes the actual stored value.