D
dramajuana
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?
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?