I am using this formula to round to 4 significant digits.
=ROUND(value,4-1-INT(LOG10(ABS(value))))
Is there a way to modify this such that excel will round to 4 sig figs using the rule of evens? Or can excel only round down at 4 and up at 5?