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?
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?
I should clarify "rule of evens". By this I do not mean Microsofts "Banker's rounding". By rule of evens I mean the rule by which if the last digit is a 5, look to the next digit to decide. If that next digit is an even number round it up and drop the 5. If it is odd, leave that digit and drop the 5.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks