Thread: Round
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Round

Hi,

Try this

=CEILING(A1,10)-1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Vladek" wrote:

I'm making price list. 150 articles and I want that every price have last
number 9.
Ex. 1651,00 = 1659,00
1255,00 = 1259,00
etc...

Help!