Devam Ediyor

Generating column of numbers based on rounding or 'leaving the same' an existing column

I have a column of numbers. I want an automated way to generate a new column of numbers based on that existing column. Here is how i want the conversion to take place:

If the value is $450 - $499.99, I want it to just copy the value (keep it the same). Same thing (just copy) if the value is $950- $999.99, $1450- $1499.99, $1950-$1999.99, $2450-$2499.99, $2950-$2999.99, $3450- $3499.99, $[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], 6950-6999.99.

If the value is $500 - $550, I want it put a value of 500. Same thing (round down to nearest multiple of 50) if the value is $1000-1050, $1500- $1550, $2000-2050, $2500-2550, $3000-3050, $3500- $3550,

Then, switch gears a little bit: $4000-4075 (note that the increment is changing from this point forward to 75 "unit" ranges), 4500-4575 , 5000-5075, 5500-5575, 6000-6075, 6500- 6575, 7000-7075.

Beceriler: Excel

Daha fazlasını görün: gears, Column, generate numbers, rounding excel, copy 7000, excel copy value, numbers 5000 6000, rounding, forward numbers, column conversion, change numbers column xcel, based phone numbers bulk, 500 numbers, excel 6500, xcel spreadsheets sort numbers column, adding numbers column vba, adding asp net existing html based site, numbers column text file java, excel formulas assign rank based range numbers, 500 999, conversion bit bit, excel column conversion, incrementing numbers column macro excel, numbers 500 excel, unit conversion

İşveren Hakkında:
( 3 değerlendirme ) Havertown, United States

Proje NO: #6554410

Seçilen:

kher78

Hello, I can do this tonight if you'd like. I don't know if you would like just a new worksheet or to modify one of your existing but I can do either.

0 gün içinde 15$ USD
(14 Değerlendirme)
3.8

9 freelancer bu iş için ortalamada 25$ teklif veriyor

mkdoluweera

Dear sir. I can complete your requirement, please check my win projects and their reviews. [url removed, login to view] Waiting for your reply. Thank you

1 gün içinde 30$ USD
(8 Değerlendirme)
3.1
kiranshoor

I am ready to do the job immediately. I work sincerely and with dedication. I am having twenty years of experience in Internet Research Computer Skills, Data Entry, Copy Paste, Microsoft Excel, Word, PDF Conversion Daha fazlası

1 gün içinde 30$ USD
(8 Değerlendirme)
2.7
jhontomasson

I would like to offer my services. I will help you complete your tasks according to your wishes and expectations. I am a new freelancer here, but I already have experience,My experience is similar to your needs, I a Daha fazlası

in 2 gün içinde50$ USD
(1 Değerlendirme)
0.8
durga10

Hi, I am available 5 days a week and 9-10 hrs in a day and have good internet speed as well as typing of 55 wpm. I am working as a data analysts. Looking for a project, Durga

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
omerqayyum789

100% job satisfaction. i am expert in excel i am doing this work since 2011 on diffrent site. I know the time is so important, i will do my work in time. payment after work. thanks let discuss it in pv

1 gün içinde 25$ USD
(0 Değerlendirme)
2.9
Thavinga

I am a Computer Science and Engineering student who is good with Ms Office package. Also I hold a Microsoft Office Certificate. I hope I would be the best candidate for this project. Thank you.

1 gün içinde 15$ USD
(0 Değerlendirme)
0.0
Aphya

Hello I do understand how you want the new column to be generated. Using my Excel skills , I can accomplish this task for you within a day. I am available for any talks. Thank you.

1 gün içinde 15$ USD
(0 Değerlendirme)
0.0
meeyaw

A proposal has not yet been provided

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0