Swedish rounding.

thing

unread,

Aug 5, 2001, 12:45:05 AM8/5/01

to

Is it possible to set a condition so that results wills be rounded to a
figure usable for sale, i.e rounding from $1.63 to $1.65. In New Zealand we
have long since abandoned the 1 and 2 cent pieces so rely on the Swedish
rounding system.

Any help would be great.

Ta

David J. Braden

unread,

Aug 5, 2001, 1:25:54 AM8/5/01

to

Yes, but you need to be more specific. Do yo want only to round cents?
How would the following round?
1.32
1.34
1.35
1.37
1.38
1.42
1.44
1.45
1.47
`.48

Dave Braden

In article <cf4b7.823$fg7.1...@news.xtra.co.nz>, thing
<th...@xtra.co.nz> wrote:

--
E-mail (ROT-13'ed): qoe...@ebpurfgre.ee.pbz

Ken Parker

unread,

Aug 5, 2001, 2:24:07 AM8/5/01

to

Try the MROUND( ) in Analysis ToolPak check that it is listed and checked in the Add-Ins dialog box.
=MROUND(1.63,0.05)
HTH

thing <th...@xtra.co.nz> wrote in message news:cf4b7.823$fg7.1...@news.xtra.co.nz...

thing

unread,

Aug 5, 2001, 3:09:12 AM8/5/01

to

Yes I would like only to round cents (unless of course going from $1.99 to
$2.00).

1s 2s 8s and 9s would go to 0
3s 4s 6s and 7s to 5.

where to from here??
David J. Braden wrote in message
<050820010125549381%no...@ugotta.bekidding.com>...

thing

unread,

Aug 5, 2001, 3:32:18 AM8/5/01

to

Thanks Ken.

That one got it.

Ken Parker wrote in message ...

Norman Harker

unread,

Aug 5, 2001, 3:48:33 AM8/5/01

to

Hi "thing"

Out of interest, in Australia we got rid of the 1 & 2 cents coins a few
years back but for supermarket pricing purposes they are still shown and
used until you get to the total that is then rounded to the nearest 5c.

1,2,8,9 go to 0
3,4,6,7 go to 5

So here we'd use MROUND(A1,0.05) but only apply to the total.

Of course supermarkets still win with most items priced at $1.99 and $1.98

One guy insisted on getting separate sets of totals and put things through
in ways that exploited the rounding! He was most unpopular with the queue
behind him and eventually got barred!

Sees Ya!

"thing" <th...@xtra.co.nz> wrote in message

news:0I6b7.938$fg7.2...@news.xtra.co.nz...

Tom Ogilvy

unread,

Aug 5, 2001, 9:46:35 AM8/5/01

to

=ROUND((A1)*20,0)/20

Should work.

Regards,
Tom Ogilvy

thing <th...@xtra.co.nz> wrote in message

news:Pm6b7.929$fg7.1...@news.xtra.co.nz...

David J. Braden

unread,

Aug 5, 2001, 11:55:13 PM8/5/01

to

Thing, Ken,

Ken's on the mark, obviously, but I suggest you lean towards what Tom O
posted. This could be a function of my overall grumpiness and distaste
for Analysis Toolpak, but IMO if you can avoid a load for something so
simple, do so. If that workbook that uses ATP travels to another
computer that doesn't have it installed, then yo have some needless
hassle.

Regards,
Dave Braden
MVP - Excel

In article <0I6b7.938$fg7.2...@news.xtra.co.nz>, thing
<th...@xtra.co.nz> wrote:

--
E-mail (ROT-13'ed): qoe...@ebpurfgre.ee.pbz

dave pritchard

unread,

Aug 6, 2001, 5:33:41 AM8/6/01

to

Australian rounding no doubt!
You would think that with 1 and 2 cent coins no longer being legal tender
all prices should be rounded to the nearest 5 cents.

Dave

"Norman Harker" <nha...@ozemail.com.au> wrote in message
news:oT6b7.4592$257.2...@ozemail.com.au...

Norman Harker

unread,

Aug 7, 2001, 4:19:22 AM8/7/01

to

Hi Dave!

It was really an anti-inflationary move. They reckoned that everyone would
round up to the nearest 5c. So prices stayed the same and only totals were
rounded, and that was in accordance with a roundup/rounddown rule.

Here the consumers are supposed to be the boss. Ha! Ha!

Sees Ya!
"dave pritchard" <dave(remove)@beachpalms.com.au> wrote in message
news:#0nE60uHBHA.840@tkmsftngp05...