View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dramajuana dramajuana is offline
external usenet poster
 
Posts: 7
Default 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?