Synatx Help

[108monkeys]

I have a range of numbers and want to return a rounded value of 10% in increments of 50.

For example, the following Numbers give the associated Answers:

Number - Answer:
1,000 - 100
1,526 - 150
2,010 - 200
2,600 - 250
3,125 - 300
4,552 - 450

What syntax do I need to use to give me the above answer?

Thanks in advance, Hanuman.

 

[JoeMo]

I have a range of numbers and want to return a rounded value of 10% in increments of 50.

For example, the following Numbers give the associated Answers:

Number - Answer:
1,000 - 100
1,526 - 150
2,010 - 200
2,600 - 250
3,125 - 300
4,552 - 450

What syntax do I need to use to give me the above answer?


Thanks in advance, Hanuman.

Here's one way to do this:

Excel Workbook
	A	B
1	1000	100
2	1526	150
3	2010	200
4	2600	250
5	3125	300
6	4552	450
Sheet8

 

[108monkeys]

Thanks JoeMo! That works beautifully!

 

[pgc01]

Hi Hanuman

Also:

=MROUND(A1/10,50)

Remark: your examples are not clear, as they are cases where you always round down.

So, for 1780, 10% is 178, rounded to the nearest multiple of 50 is 200. Is this correct or you meant round down?

 

[108monkeys]

I don't have a MROUND function? The lower value of 150 would be the answer I require. Thanks for the feedback. Regards, Hanuman.

 

[pgc01]

I don't have a MROUND function?

In older versions of excel to have access to some functions you have to enable the Toolpak add-in (in Tools->Add-ins)

The lower value of 150 would be the answer I require

If you always want to round down, then maybe:

=FLOOR(A1*10%,50)

 

[108monkeys]

That works even better. I also managed to activate the MROUND. Good to know!

Thanks, Hanuman.