Round
in [Functions]
|
Prev: Updating Consecutive Cells in a Range
Next: Calculating percent of times a value is in a column and total #
From: Vladek on 26 Mar 2010 04:49 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!
From: Jarek Kujawa on 26 Mar 2010 05:01 =INT(A1/10)*10+9 HIH On 26 Mar, 09:49, Vladek <Vla...(a)discussions.microsoft.com> 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!
From: Mike H on 26 Mar 2010 05:43 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!
From: Vladek on 26 Mar 2010 06:21 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 <Vla...(a)discussions.microsoft.com> 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! > > . >
From: Vladek on 26 Mar 2010 06:21
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! |