Rounding to the nearest quarter hour no longer working
Figured it out. Disabling the ATP, shutting down Excel, starting Excel,
enabling the ATP, and shutting down and restarting Excel did it, for some
reason. Thanks for the help.
"dramajuana" wrote:
I have a time sheet that I've been using for several months, and today it's
been acting funky.
I have the sheet calculating the hours for the day in, say, A1, and I have
it rounding those hours to the nearest quarter hour in A2 with the formula
=MROUND(A1,0.25).
It has always worked in the past, but today, my rounding in A2 is coming up
as #NAME. I checked my previous documents, and if I try and edit those in any
way, it changes my rounded results to #NAME.
I have already checked and made sure that the Analysis Toolpack is loaded to
no avail. Any ideas?
|