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

Thx, it works! :))
This helps me a lot!

Korisnik "Jarek Kujawa" napisao je:

=INT(A1/10)*10+9

HIH

On 26 Mar, 09:49, 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!


.