return odd number in 1000

[LarsSJensen]

Hi

I have alot of data, that i need to convert.

value in system	new value (the formula that i need)
8726,36	9000
8971,84	9000
56724,62	57000
7000,1	9000
846618,09	847000

<tbody>
</tbody>

what i got so fare is =ROUNDUP(ODD((ROUNDUP(R3;-3)));-3)

but it doesnt work

i need the value in the system to roundup by the thousand, and if that value is odd (7000 is odd, and 8000 is evan) then nothing, but if the value is even, then raound up to the to an odd thousand value

Hope it makes sence, and hope you guys can help me

 

[VBA Geek]

Excel 2010
	A	B
1	value in system	new value (the formula that i need)
2	8726.36	9000
Sheet23

Cell Formulas
Range	Formula
B2	=ISEVEN(CEILING(A2,1000)/1000)*1000+CEILING(A2,1000)

 

[becci.gott]

Just to understand a little more.. because the 1000 multiples are by definition even, I can see why this isn't working for you...

I presume that what you mean is if the numbers preceding the zeros is odd (i.e. 847) then use it, whereas if the number is 848 (000) then it needs to round up to the next 1000..

 

[JustynaMK]

Hi Lars,

How about:
=ODD(ROUNDUP(A1/1000,0))*1000

 

[LarsSJensen]

Excel 2010

	A	B
1	value in system	new value (the formula that i need)
2	8726.36	9000

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet23​

Worksheet Formulas Cell Formula B2 =ISEVEN(CEILING(A2,1000)/1000)*1000+CEILING(A2,1000) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

wow really quick answer, yeah the formular you posted works for me thanks

 

[LarsSJensen]

Hi

i tested your formula as well, and it works (from my small test) but what is the difference between your and =ISEVEN(CEILING(A2,1000)/1000)*1000+CEILING(A2,1000) ??
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"><select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]



the difference


<select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]



the difference


<select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]



the difference


<select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]



the difference


<select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]



the difference


<select class="tw-lang-selector vk_txt" data-dslc="da" data-dsln="Dansk" data-uiln="dansk" data-url="/setprefs?sig=0_5Mr30-pg4itgwQfPYWy-PjgqqrU%3D&prev=https://www.google.dk/search?q%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26rlz%3D1C1GCEA_enDK781DK781%26oq%3Dforskellen%2Bp%25C3%25A5%2Bengelsk%26aqs%3Dchrome..69i57j0l5.3863j0j7%26sourceid%3Dchrome%26ie%3DUTF-8" id="tw-sl" data-dlm="Registrer sprog" jsaction="change:tob.lc" data-ved="0ahUKEwj1oNuZtKrZAhWLqaQKHfo5BD0Q8TQIKjAA" style="background: transparent; border-width: initial; border-style: none; border-color: initial; color: rgb(84, 84, 84); list-style: none; margin: 0px; outline: none; height: 20px; -webkit-appearance: none; width: 79px; font-size: 13px !important;"><option value="---" disabled="">---------------</option><option value="auto" id="tw-dslo">Registrer sprog</option><option value="af">Afrikaans</option><option value="sq">Albansk</option><option value="am">Amharisk</option><option value="ar">Arabisk</option><option value="hy">Armensk</option><option value="az">Aserbajdsjansk</option><option value="eu">Baskisk</option><option value="bn">Bengali</option><option value="bs">Bosnisk</option><option value="bg">Bulgarsk</option><option value="my">Burmesisk</option><option value="ca">Catalansk</option><option value="ceb">Cebuano</option><option selected="1" value="da">Dansk</option><option value="en">Engelsk</option><option value="eo">Esperanto</option><option value="et">Estisk</option><option value="fi">Finsk</option><option value="fr">Fransk</option><option value="fy">Frisisk</option><option value="gl">Galicisk</option><option value="ka">Georgisk</option><option value="el">Græsk</option><option value="gu">Gujarati</option><option value="ht">Haitisk</option><option value="ha">Hausa</option><option value="haw">Hawaiiansk</option><option value="iw">Hebraisk</option><option value="hi">Hindi</option><option value="hmn">Hmong</option><option value="nl">Hollandsk</option><option value="be">Hviderussisk</option><option value="ig">Igbo</option><option value="id">Indonesisk</option><option value="ga">Irsk</option><option value="xh">IsiXhosa</option><option value="is">Islandsk</option><option value="it">Italiensk</option><option value="ja">Japansk</option><option value="jv">Javanesisk</option><option value="yi">Jiddisch</option><option value="kn">Kannada</option><option value="kk">Kasakhisk</option><option value="km">Khmer</option><option value="zh-CN">Kinesisk (forenklet)</option><option value="zh-TW">Kinesisk (traditionelt)</option><option value="ky">Kirgisisk</option><option value="ko">Koreansk</option><option value="co">Korsikansk</option><option value="hr">Kroatisk</option><option value="ku">Kurdisk</option><option value="lo">Lao</option><option value="la">Latin</option><option value="lv">Lettisk</option><option value="lt">Litauisk</option><option value="lb">Luxembourgsk</option><option value="mk">Makedonsk</option><option value="mg">Malagassisk</option><option value="ms">Malajisk</option><option value="ml">Malayalam</option><option value="mt">Maltesisk</option><option value="mi">Maori</option><option value="mr">Marathisk</option><option value="mn">Mongolsk</option><option value="ne">Nepalesisk</option><option value="no">Norsk</option><option value="ny">Nyanja</option><option value="ps">Pashto</option><option value="fa">Persisk</option><option value="pl">Polsk</option><option value="pt">Portugisisk</option><option value="pa">Punjabisk</option><option value="ro">Rumænsk</option><option value="ru">Russisk</option><option value="sm">Samoansk</option><option value="sr">Serbisk</option><option value="sn">Shona</option><option value="sd">Sindhi</option><option value="si">Singalesisk</option><option value="gd">Skotsk gælisk</option><option value="sk">Slovakisk</option><option value="sl">Slovensk</option><option value="so">Somali</option><option value="es">Spansk</option><option value="su">Sundanesisk</option><option value="sv">Svensk</option><option value="sw">Swahili</option><option value="st">Sydsotho</option><option value="tg">Tadsjikisk</option><option value="tl">Tagalog</option><option value="ta">Tamil</option><option value="te">Telugu</option><option value="th">Thai</option><option value="cs">Tjekkisk</option><option value="tr">Tyrkisk</option><option value="de">Tysk</option><option value="uk">Ukrainsk</option><option value="hu">Ungarsk</option><option value="ur">Urdu</option><option value="uz">Usbekisk</option><option value="vi">Vietnamesisk</option><option value="cy">Walisisk</option><option value="yo">Yoruba</option><option value="zu">Zulu</option></select><select class="tw-lang-selector vk_txt vk_dgy tw-dl" style="color: rgb(84, 84, 84); background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: initial; border-style: none; border-color: initial; list-style: none; margin: 0px; outline: none; height: 20px; position: absolute; visibility: hidden; font-size: 13px !important;"><option>Dansk</option></select>
[COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR][COLOR=rgba(0, 0, 0, 0.54)]<svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
</path></svg>[/COLOR]
[/COLOR]


the difference


</body>

 

[LarsSJensen]

ohh i tested both in my data set, and if the system value is e.g -59.5

system value	=ISEVEN(CEILING(A2,1000)/1000)*1000+CEILING(A2,1000)	=ODD(ROUNDUP(A1/1000,0))*1000
-59,5	1000	-1000

<tbody>
</tbody>

and here i want the value 1000

its regarding calculation customers credit limit for work

 

[VBA Geek]

ohh i tested both in my data set, and if the system value is e.g -59.5

system value	=ISEVEN(CEILING(A2,1000)/1000)*1000+CEILING(A2,1000)	=ODD(ROUNDUP(A1/1000,0))*1000
-59,5	1000	-1000

<tbody>
</tbody>

and here i want the value 1000

its regarding calculation customers credit limit for work

so are you getting the desired value?

 

[LarsSJensen]

Yes i did thanks