Thread: Rounding to the nearest 25 including negative numbers??
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Rounding to the nearest 25 including negative numbers??
On Sat, 9 May 2009 09:38:01 -0700, Bob wrote:

I have the following formula
=CEILING(Sheet4!BY6, 25)
How I get it to round negative numbers too

It works with positive numbers but when I insert ie -360, it should read
-350 but I get the following #NUM!

=round(sheet4!BY6/25,0)*25
--ron
Reply With QuoteReply With Quote