Thread: Is there a formula to round a number to the nearest .09?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Is there a formula to round a number to the nearest .09?
There has to be a better way but try this for now

=IF(A1<0,ROUND(A1,1)-0.01,"")

Mike

"WenMess" wrote:

I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is there a
formula/function that would do this?
Reply With QuoteReply With Quote