Posted to microsoft.public.excel.worksheet.functions

[email protected] nma2@yahoo.com is offline

external usenet poster

Posts: 1

Not understanding MROUND

Can somone answer an MROUND question for me?

Situation:

MROUND with a multiple of .1 rounds 773.65 to 773.6
MROUND with a multiple of .1 rounds 921.65 to 921.7

Isn't the remainder the same for both values? Shouldn't it round up
for both of these values?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MROUND	cheeser83	Excel Discussion (Misc queries)	7	January 6th 07 04:07 AM
MRound	Lucky_guy2000	Excel Discussion (Misc queries)	2	April 21st 06 01:44 PM
SUM & MROUND Formulas	dewey	Excel Discussion (Misc queries)	3	October 26th 05 09:40 AM
Mround to nearest 5 c	Giorgos	Excel Discussion (Misc queries)	1	July 5th 05 11:48 AM
Mround	ynissel	Excel Discussion (Misc queries)	1	June 2nd 05 05:32 PM

All times are GMT +1. The time now is 09:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us