Help! Rounding Up Formula

  • Thread starter Thread starter LarryUSCGMWR
  • Start date Start date
L

LarryUSCGMWR

I posted to this community and it says when I tried to open the thread that
"Community Message Not Available". What does this mean? My question was to
find a formula to round up a number to the next higher integer that is a
multiple of 5. Please email me at (e-mail address removed).
Thanks
Larry
 
LarryUSCGMWR said:
I posted to this community and it says when I tried to open the thread that
"Community Message Not Available". What does this mean? My question
was to find a formula to round up a number to the next higher integer that
is a
multiple of 5.
Click to expand...

Your first message got posted correctly, and it has already been answered.
(Simply put, CEILING(A1,5).)

The "message not available" message probably reflects a temporary networking
problem, where can exist anywhere between the MS server and your own
computer. If you get the same message before and after successfully posting
a message, I would suspect the "community" web server. I don't use that web
server.
 
Check your previous post.. You can try the worksheet function CEILING() or
work around with the IF() and MOD() function to acheive this...

If this post helps click Yes
 
Back
Top