LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default MROUND formula problem, help please!

What i need is to have numbers which are in in some number ranges
rounded to use them with MROUND formula but according to more conditions
(according to in which range some number is to round it properly) and i
am struggling all day with no succes with this MROUND issue!

Situation is like this:
-if the number is in range from 1,01 - 2,00 numbers should be round by
0,01 'Multiple' mark
- if the number is in range 2,00 - 3,00 number should be rounded by 0,02
- if number is from 3,00 - 4,00 marks are with 0,05
- if number is from 4,00 - 6,00 marks are 0,10
- if number is from 6,00 - 10,00 marks are 0,20
- if number is from 10,00 - 20,00 marks are 0,50
- if number is from 20,00 - 30,00 marks are 1,00
- if number is from 30,00 - 100,00 marks are 5,00
- if number is from 100,00 - 1000,00 marks are 10,00


Example: if number is 2.111 to be rounded on 2.12 by 'Multiple' of 0,02
or if number is 6,699 to be rounded to 6,60 with 0,20 'multiple' mark

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
MRound and Roundup adodson Excel Worksheet Functions 4 April 11th 06 12:13 AM
SUM & MROUND Formulas dewey Excel Discussion (Misc queries) 3 October 26th 05 09:40 AM
Mround ynissel Excel Discussion (Misc queries) 1 June 2nd 05 05:32 PM


All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"