MROUND formula problem, help please!

[Ivica TypeR]

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!

 

[Peo Sjoblom]

Try something like

=IF(A1="","",MROUND(A1,VLOOKUP(A1,{0,0;1.01,0.01;2,0.02;3,0.05;4,0.1;6,0.2;10,0.5;20,1;30,5;100,10},2)))

 

[Ivica TypeR]

Try something like

=IF(A1="","",MROUND(A1,VLOOKUP(A1,{0,0;1.01,0.01;2,0.02;3,0.05;4,0.1;6,0.2;10,0.5;20,1;30,5;100,10},2)))

now i have one more problem, don't know what is yours ;

you see, i'm from europe and yours , is mine ;
. is ,

so don't know what to input instead of yours ;

so can't try this formula :-(

 

[Ivica TypeR]

Try something like

=IF(A1="","",MROUND(A1,VLOOKUP(A1,{0,0;1.01,0.01;2,0.02;3,0.05;4,0.1;6,0.2;10,0.5;20,1;30,5;100,10},2)))

i made it! really great, this is formula in 'my language' - little
different from yours suggestion:

=MROUND(A1;CHOOSE(MATCH(A1;{1,01;2;3;4;6;10;20;30;100});0,01;0,02;0,05;0,1;0,2;0,5;1;5;10))


tnx for help