need macro or formula ?

[Jagat Pavasia]

dear sir,

My A1 have amount of figure, like 15000, 25000, 35200, 70325 etc.

I want that if My figure is :
1 to 10,000 then result in B1 10,000
10,001 to 20,000 then 20,000
20,001 to 30,000 then 30,000
30,001 to 40,000 then 40,000
40,001 to 50,000 then 50,000
50,001 to 60,000 then 60,000

60,001 to 1,00,000 then 1,00,000
1,00,101 to 1,30,000 then 1,30,000
1,30,001 to 1,60,000 then 1,60,000
1,60,001 to 2,00,000 then 2,00,000
2,00,001 to 2,50,000 then 2,50,000
2,50,001 to 2,75,000 then 2,75,000
2,75,001 to 3,00,000 then 3,00,000.



did i need macro or formula, please help me

 

[shinigamilight]

Create a table like I've created below and use this formula

G6: =VLOOKUP(F6,$B$6:$C$18,2,1)

 

[kevin9999]

Another option (with examples)

Book1
	A	B
1	5,050	10,000
2	15,478	20,000
3	22,580	30,000
4	31,311	40,000
5	48,755	50,000
6	51,500	60,000
7
8	60,001	100,000
9	100,001	130,000
10	160,001	200,000
11	130,001	160,000
12	200,001	250,000
13	250,001	275,000
14	275,001	300,000
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=CEILING(A1,10000)
B8:B14	B8	=IFS(A8<=100000,100000,A8<=130000,130000,A8<=160000,160000,A8<=200000,200000,A8<=250000,250000,A8<=275000,275000,A8<300000,300000)