Thread: rounding a number up to a certain ending digit
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default rounding a number up to a certain ending digit
you may also have greater flexibility with this one

=--((LEFT(A1,LEN(A1)-1)*10)+9)

--
isabelle



Le 2012-05-04 17:22, isabelle a écrit :
hi,

=--(LEFT(A1,LEN(A1)-1)&9)

Reply With QuoteReply With Quote