Thread: Round
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vladek Vladek is offline
external usenet poster
 
Posts: 3
Default Round

Thanks,

it's working!



Korisnik "Mike H" napisao je:

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!