Thread: Round
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Round
=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!

Reply With QuoteReply With Quote