Round

[Vladek]

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!

 

[Jarek Kujawa]

=INT(A1/10)*10+9

HIH

 

[Mike H]

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]

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

Korisnik "Jarek Kujawa" napisao je:

 

[Vladek]

Thanks,

it's working!



Korisnik "Mike H" napisao je: