Thread: How to round negative and positive numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default How to round negative and positive numbers

You didn't state it has to be rounded up or down, with your formula,
16.2558 gets rounded to 20.. I am not sure if that is what you want.

Try this..

=IF(Q890, mround(Q89, 5), mround(Q89*-1, 5)*-1)

If you want all number to round up, change mround to ceiling


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=558490

Reply With QuoteReply With Quote