Thread: How to round negative and positive numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
  
Posts: 418
Default How to round negative and positive numbers
Bearacade wrote:
=IF(Q890, mround(Q89, 5), mround(Q89*-1, 5)*-1)

Why Q89*-1 when -Q89 would seem to do just as well?

Reply With QuoteReply With Quote