Привет на всички от форума,

Знае ли някой, дали има възможност едно число - например, 5,14528 - не само да се закръгли на 5,15000, но и да се чете от Ексел именно като 5.15.

Благодаря

Съдържаниет е скрито
Влезте за да го видите

=MROUND(AB4,0.005)

Съдържаниет е скрито
Влезте за да го видите

Не винаги се получава, обаче

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите

=ROUND(посочва се клетката, в която е числото,2)

Това е закръгление до стотици. За хилядни се вкарва 3 и т.н.

Съдържаниет е скрито
Влезте за да го видите

Редактирано от Eжko_ на 24.02.10 15:38.

Следващото нещо, което ми трябва, е да направя така, щото числото 5,15 да го търся в масив от данни. На числото 5,15 м този масим от данни, съответства някаква стойност, и тази стойност ми трябва да я "върна" там, където правя изчисленията.

Има ли някой идея ?

Съдържаниет е скрито
Влезте за да го видите

проучи формулите VLOOKUP, INDEX и MATCH.
има теми назад във форума за тях, има и достатъчно информация в гугъл.
ако не се справиш - ще помагаме

Ежко_ ти си Мъжжж , задаваш и си отговаряш Сам

Съдържаниет е скрито
Влезте за да го видите

Благодаря за вниманието.

Трудно ми е да се справя.

Задачата е следната: От поредица от изчисления получавам резултат - примерно числото 5.15. Такава стойност имам на съответен ред в в съответна клетка в колона "А" на друг лист, където има още 100 стойности в 100 клетки в същата колона (примерно). В колона "В" на съответния ред (тоест, клетката отдясно на 5,15) се намира стойността, която търся да извлека.

Ако можете, помогнете.

Благодаря на всички ви.

Съдържаниет е скрито
Влезте за да го видите

Редактирано от Eжko_ на 25.02.10 08:47.

Всяко едно от чисбата е уникално, както и съответстващата му стойност, която търся да извлека.

Съдържаниет е скрито
Влезте за да го видите

човек, VLOOKUP ти трябва в случая.
ето ти една тема от доста отдавна

Съдържаниет е скрито
Влезте за да го видите

Благодаря ти

Пробвах "=VLOOKUP(AD4,A:B,2,TRUE)"

При някои стойности се получава, при други "се лъже" и показва онова, което отговаря на стойности една клетка преди това. Примерно, търся какво отговаря на 0,57, а то ми показва на 0,56. Не знам защо някъде намира коректно, а другаде - не.

А с ",FALSE" дава #N/A

Съдържаниет е скрито
Влезте за да го видите

Редактирано от Eжko_ на 25.02.10 15:56.

Тъкмо щях да се отказвам, когато реших да напиша някои числа на ръка. Ще поясня - значи, масивът с базата данни е от 1599 числа - започва от 0.01 и завършва на 15,99. ЗА на ге ги пиша на ръка, написах в една клетка 0,01, след което в долната съставих формула, като посочвам клетката и прибавям 0.01. Така стигнах до 15.99. Оттук копирах само стойностите, без формулите. Да, ама това явно създава проблем при тази функция, не мога да си обясня защо. Когато започнах да пиша наново стойностите, там, където има проблем, нещата се оправят. Работата е там, че трябва да оправям немалко числа. Но, слава Богу, няма място за недоволство.

Благодаря още веднъж на всички.

Съдържаниет е скрито
Влезте за да го видите

False, бате, задължително използвай False.
но имай предвид едно - ако имаш едно число няколко пъти, то ще ти върне първата стойност

е тука вече ме загуби.
нищо не разбрах

Всичките стойности са уникални - както казах, започват от 0,01 и свършват до 15.99 - всичко на всичко 1599 числа, все различни.

Когато използвам "False", се появава #N/A
- въпреки че стойностите ми са подредени перфектно - от най-малката към най-голямата.

Съдържаниет е скрито
Влезте за да го видите

Функцията, казано най-просто се "шашка" от това, че числата са продукт на формули. Когато ги въвеждам "ръчно", няма проблем. Такова нещо не ми се е случвало досега, но - поне дасега - не виждам друга причина.

Съдържаниет е скрито
Влезте за да го видите

най-добре ми прати един файл.
така да си говорим - само се объркваме взаимно

...започва от 0.01 и завършва на 15,99...

Не, че ми работа да се меся където има толкова по-знаещи от мен,
ама в текста поне ту ползваш десетична точка, ту запетая..
Да няма нещо някакво такова и в таблицата?

Ако не можеш да разбереш, ще ти препоръчавм да направиш следното. Напиши в А1 0,01. Копирай надолу с формула: "А2=A1+0.01" - примерно, 100 записа. В колона B задай съответни стойности, независимо какви. Тогава се опитай да използваш функцията и виж какъв ще е резултата.

Съдържаниет е скрито
Влезте за да го видите

Ако има нещо нередно, обикновено дава резултат #VALUE!

Тук не става въпрос затова. Ползвам екселските таблици по-вече от 11 години - не че съм наясно кой-знае колко, но поне за това, което говориш, не е проблема.

Съдържаниет е скрито
Влезте за да го видите

В А1 Пиша 0.01. В А2 съставям формулата =А1+0.01. След като копирам надолу, копирам и стойностите със "пас спешъл". Ето какво се получава :

0.010000000000000000000000000000000
0.020000000000000000000000000000000
0.030000000000000000000000000000000
0.040000000000000000000000000000000
0.050000000000000000000000000000000
0.060000000000000000000000000000000
0.070000000000000000000000000000000
0.080000000000000000000000000000000
0.090000000000000000000000000000000
0.100000000000000000000000000000000
0.110000000000000000000000000000000
0.120000000000000000000000000000000
0.130000000000000000000000000000000
0.140000000000000000000000000000000
0.150000000000000000000000000000000
0.160000000000000000000000000000000
0.170000000000000000000000000000000
0.180000000000000000000000000000000
0.190000000000000000000000000000000
0.200000000000000000000000000000000
0.210000000000000000000000000000000
0.220000000000000000000000000000000
0.230000000000000000000000000000000
0.240000000000000000000000000000000
0.250000000000000000000000000000000
0.260000000000000000000000000000000
0.270000000000000000000000000000000
0.280000000000000000000000000000000
0.290000000000000000000000000000000
0.300000000000000000000000000000000
0.310000000000000000000000000000000
0.320000000000000000000000000000000
0.330000000000000000000000000000000
0.340000000000000000000000000000000
0.350000000000000000000000000000000
0.360000000000000000000000000000000
0.370000000000000000000000000000000
0.380000000000000000000000000000000
0.390000000000000000000000000000000
0.400000000000000000000000000000000
0.410000000000000000000000000000000
0.420000000000000000000000000000000
0.430000000000000000000000000000000
0.440000000000000000000000000000000
0.450000000000000000000000000000000
0.460000000000000000000000000000000
0.470000000000000000000000000000000
0.480000000000000000000000000000000
0.490000000000000000000000000000000
0.500000000000000000000000000000000
0.510000000000000000000000000000000
0.520000000000000000000000000000000
0.530000000000000000000000000000000
0.540000000000000000000000000000000
0.550000000000000000000000000000000
0.560000000000000000000000000000000
0.570000000000000000000000000000000
0.580000000000000000000000000000000
0.590000000000000000000000000000000
0.600000000000000000000000000000000
0.610000000000000000000000000000000
0.620000000000000000000000000000000
0.630000000000000000000000000000000
0.640000000000000000000000000000000
0.650000000000000000000000000000000
0.660000000000000000000000000000000
0.670000000000000000000000000000000
0.680000000000000000000000000000000
0.690000000000000000000000000000000
0.700000000000000000000000000000000
0.710000000000000000000000000000000
0.720000000000000000000000000000000
0.730000000000000000000000000000000
0.740000000000000000000000000000000
0.750000000000000000000000000000000
0.760000000000000000000000000000000
0.770000000000000000000000000000000
0.780000000000000000000000000000000
0.790000000000000000000000000000000
0.800000000000000000000000000000000
0.810000000000000000000000000000000
0.820000000000001000000000000000000
0.830000000000001000000000000000000
0.840000000000001000000000000000000
0.850000000000001000000000000000000
0.860000000000001000000000000000000
0.870000000000001000000000000000000
0.880000000000001000000000000000000
0.890000000000001000000000000000000
0.900000000000001000000000000000000
0.910000000000001000000000000000000
0.920000000000001000000000000000000
0.930000000000001000000000000000000
0.940000000000001000000000000000000
0.950000000000001000000000000000000
0.960000000000001000000000000000000
0.970000000000001000000000000000000
0.980000000000001000000000000000000
0.990000000000001000000000000000000
1.000000000000000000000000000000000
1.010000000000000000000000000000000
1.020000000000000000000000000000000
1.030000000000000000000000000000000
1.040000000000000000000000000000000
1.050000000000000000000000000000000
1.060000000000000000000000000000000
1.070000000000000000000000000000000
1.080000000000000000000000000000000
1.090000000000000000000000000000000
1.100000000000000000000000000000000
1.110000000000000000000000000000000
1.120000000000000000000000000000000
1.130000000000000000000000000000000
1.140000000000000000000000000000000
1.150000000000000000000000000000000
1.160000000000000000000000000000000
1.170000000000000000000000000000000
1.180000000000000000000000000000000
1.190000000000000000000000000000000
1.200000000000000000000000000000000
1.210000000000000000000000000000000
1.220000000000000000000000000000000
1.230000000000000000000000000000000
1.240000000000000000000000000000000
1.250000000000000000000000000000000
1.260000000000000000000000000000000
1.270000000000000000000000000000000
1.280000000000000000000000000000000
1.290000000000000000000000000000000
1.300000000000000000000000000000000
1.310000000000000000000000000000000
1.320000000000000000000000000000000
1.330000000000000000000000000000000
1.340000000000000000000000000000000
1.350000000000000000000000000000000
1.360000000000000000000000000000000
1.370000000000000000000000000000000
1.380000000000000000000000000000000
1.390000000000000000000000000000000
1.400000000000000000000000000000000
1.410000000000000000000000000000000
1.420000000000000000000000000000000
1.430000000000000000000000000000000
1.440000000000000000000000000000000
1.450000000000000000000000000000000
1.460000000000000000000000000000000
1.470000000000000000000000000000000
1.480000000000000000000000000000000
1.490000000000000000000000000000000
1.500000000000000000000000000000000
1.510000000000000000000000000000000
1.520000000000000000000000000000000
1.530000000000000000000000000000000
1.540000000000000000000000000000000
1.550000000000000000000000000000000
1.560000000000000000000000000000000
1.570000000000000000000000000000000
1.580000000000000000000000000000000
1.590000000000000000000000000000000
1.600000000000000000000000000000000
1.610000000000000000000000000000000
1.620000000000000000000000000000000
1.630000000000000000000000000000000
1.640000000000000000000000000000000
1.650000000000000000000000000000000
1.660000000000000000000000000000000
1.670000000000000000000000000000000
1.680000000000000000000000000000000
1.690000000000000000000000000000000
1.700000000000000000000000000000000
1.710000000000000000000000000000000
1.720000000000000000000000000000000
1.730000000000000000000000000000000
1.740000000000000000000000000000000
1.750000000000000000000000000000000
1.760000000000000000000000000000000
1.770000000000000000000000000000000
1.780000000000000000000000000000000
1.790000000000000000000000000000000
1.800000000000000000000000000000000
1.810000000000000000000000000000000
1.820000000000000000000000000000000
1.830000000000000000000000000000000
1.840000000000000000000000000000000
1.850000000000000000000000000000000
1.860000000000000000000000000000000
1.870000000000000000000000000000000
1.880000000000000000000000000000000
1.890000000000000000000000000000000
1.900000000000000000000000000000000
1.910000000000000000000000000000000
1.920000000000000000000000000000000
1.930000000000000000000000000000000
1.940000000000000000000000000000000
1.950000000000000000000000000000000
1.960000000000000000000000000000000
1.970000000000000000000000000000000
1.980000000000000000000000000000000
1.990000000000000000000000000000000
2.000000000000000000000000000000000
2.010000000000000000000000000000000
2.020000000000000000000000000000000
2.030000000000000000000000000000000
2.040000000000000000000000000000000
2.050000000000000000000000000000000
2.060000000000000000000000000000000
2.070000000000000000000000000000000
2.080000000000000000000000000000000
2.090000000000000000000000000000000
2.100000000000000000000000000000000
2.110000000000000000000000000000000
2.120000000000000000000000000000000
2.130000000000000000000000000000000
2.140000000000000000000000000000000
2.150000000000000000000000000000000
2.160000000000000000000000000000000
2.170000000000000000000000000000000
2.180000000000000000000000000000000
2.190000000000000000000000000000000
2.200000000000000000000000000000000
2.210000000000000000000000000000000
2.220000000000000000000000000000000
2.230000000000000000000000000000000
2.240000000000000000000000000000000
2.250000000000000000000000000000000
2.260000000000000000000000000000000
2.270000000000000000000000000000000
2.280000000000000000000000000000000
2.290000000000000000000000000000000
2.299999999999990000000000000000000
2.309999999999990000000000000000000
2.319999999999990000000000000000000
2.329999999999990000000000000000000
2.339999999999990000000000000000000
2.349999999999990000000000000000000
2.359999999999990000000000000000000
2.369999999999990000000000000000000
2.379999999999990000000000000000000
2.389999999999990000000000000000000
2.399999999999990000000000000000000
2.409999999999990000000000000000000
2.419999999999990000000000000000000
2.429999999999990000000000000000000
2.439999999999990000000000000000000
2.449999999999990000000000000000000
2.459999999999990000000000000000000
2.469999999999990000000000000000000
2.479999999999990000000000000000000
2.489999999999990000000000000000000
2.499999999999990000000000000000000
2.509999999999990000000000000000000
2.519999999999990000000000000000000
2.529999999999990000000000000000000
2.539999999999990000000000000000000
2.549999999999990000000000000000000
2.559999999999990000000000000000000
2.569999999999990000000000000000000
2.579999999999990000000000000000000
2.589999999999990000000000000000000
2.599999999999990000000000000000000
2.609999999999990000000000000000000
2.619999999999990000000000000000000
2.629999999999990000000000000000000
2.639999999999990000000000000000000
2.649999999999990000000000000000000
2.659999999999990000000000000000000
2.669999999999990000000000000000000
2.679999999999990000000000000000000
2.689999999999990000000000000000000
2.699999999999990000000000000000000
2.709999999999990000000000000000000
2.719999999999990000000000000000000
2.729999999999990000000000000000000
2.739999999999990000000000000000000
2.749999999999990000000000000000000
2.759999999999990000000000000000000
2.769999999999980000000000000000000
2.779999999999980000000000000000000
2.789999999999980000000000000000000
2.799999999999980000000000000000000
2.809999999999980000000000000000000
2.819999999999980000000000000000000
2.829999999999980000000000000000000
2.839999999999980000000000000000000
2.849999999999980000000000000000000
2.859999999999980000000000000000000
2.869999999999980000000000000000000
2.879999999999980000000000000000000
2.889999999999980000000000000000000
2.899999999999980000000000000000000
2.909999999999980000000000000000000
2.919999999999980000000000000000000
2.929999999999980000000000000000000
2.939999999999980000000000000000000
2.949999999999980000000000000000000
2.959999999999980000000000000000000
2.969999999999980000000000000000000
2.979999999999980000000000000000000
2.989999999999980000000000000000000
2.999999999999980000000000000000000
3.009999999999980000000000000000000
3.019999999999980000000000000000000
3.029999999999980000000000000000000
3.039999999999980000000000000000000
3.049999999999980000000000000000000
3.059999999999980000000000000000000
3.069999999999980000000000000000000
3.079999999999980000000000000000000
3.089999999999980000000000000000000
3.099999999999980000000000000000000
3.109999999999980000000000000000000
3.119999999999980000000000000000000
3.129999999999980000000000000000000
3.139999999999980000000000000000000
3.149999999999980000000000000000000
3.159999999999980000000000000000000
3.169999999999980000000000000000000
3.179999999999980000000000000000000
3.189999999999980000000000000000000
3.199999999999980000000000000000000
3.209999999999980000000000000000000
3.219999999999980000000000000000000
3.229999999999980000000000000000000
3.239999999999970000000000000000000
3.249999999999970000000000000000000
3.259999999999970000000000000000000
3.269999999999970000000000000000000
3.279999999999970000000000000000000
3.289999999999970000000000000000000
3.299999999999970000000000000000000
3.309999999999970000000000000000000
3.319999999999970000000000000000000
3.329999999999970000000000000000000
3.339999999999970000000000000000000
3.349999999999970000000000000000000
3.359999999999970000000000000000000
3.369999999999970000000000000000000
3.379999999999970000000000000000000
3.389999999999970000000000000000000
3.399999999999970000000000000000000
3.409999999999970000000000000000000
3.419999999999970000000000000000000
3.429999999999970000000000000000000
3.439999999999970000000000000000000
3.449999999999970000000000000000000
3.459999999999970000000000000000000
3.469999999999970000000000000000000
3.479999999999970000000000000000000
3.489999999999970000000000000000000
3.499999999999970000000000000000000
3.509999999999970000000000000000000
3.519999999999970000000000000000000
3.529999999999970000000000000000000
3.539999999999970000000000000000000
3.549999999999970000000000000000000
3.559999999999970000000000000000000
3.569999999999970000000000000000000
3.579999999999970000000000000000000
3.589999999999970000000000000000000
3.599999999999970000000000000000000
3.609999999999970000000000000000000
3.619999999999970000000000000000000
3.629999999999970000000000000000000
3.639999999999970000000000000000000
3.649999999999970000000000000000000
3.659999999999970000000000000000000
3.669999999999970000000000000000000
3.679999999999970000000000000000000
3.689999999999970000000000000000000
3.699999999999970000000000000000000
3.709999999999960000000000000000000
3.719999999999960000000000000000000
3.729999999999960000000000000000000
3.739999999999960000000000000000000
3.749999999999960000000000000000000
3.759999999999960000000000000000000
3.769999999999960000000000000000000
3.779999999999960000000000000000000
3.789999999999960000000000000000000
3.799999999999960000000000000000000
3.809999999999960000000000000000000
3.819999999999960000000000000000000
3.829999999999960000000000000000000
3.839999999999960000000000000000000
3.849999999999960000000000000000000
3.859999999999960000000000000000000
3.869999999999960000000000000000000
3.879999999999960000000000000000000
3.889999999999960000000000000000000
3.899999999999960000000000000000000
3.909999999999960000000000000000000
3.919999999999960000000000000000000
3.929999999999960000000000000000000
3.939999999999960000000000000000000
3.949999999999960000000000000000000
3.959999999999960000000000000000000
3.969999999999960000000000000000000
3.979999999999960000000000000000000
3.989999999999960000000000000000000
3.999999999999960000000000000000000
4.009999999999960000000000000000000
4.019999999999960000000000000000000
4.029999999999960000000000000000000
4.039999999999960000000000000000000
4.049999999999960000000000000000000
4.059999999999960000000000000000000
4.069999999999960000000000000000000
4.079999999999960000000000000000000
4.089999999999960000000000000000000
4.099999999999960000000000000000000
4.109999999999960000000000000000000
4.119999999999960000000000000000000
4.129999999999960000000000000000000
4.139999999999960000000000000000000
4.149999999999960000000000000000000
4.159999999999960000000000000000000
4.169999999999960000000000000000000
4.179999999999960000000000000000000
4.189999999999960000000000000000000
4.199999999999950000000000000000000
4.209999999999950000000000000000000
4.219999999999950000000000000000000
4.229999999999950000000000000000000
4.239999999999950000000000000000000
4.249999999999950000000000000000000
4.259999999999950000000000000000000
4.269999999999950000000000000000000
4.279999999999950000000000000000000
4.289999999999950000000000000000000
4.299999999999950000000000000000000
4.309999999999950000000000000000000
4.319999999999950000000000000000000
4.329999999999950000000000000000000
4.339999999999950000000000000000000
4.349999999999950000000000000000000
4.359999999999950000000000000000000
4.369999999999950000000000000000000
4.379999999999950000000000000000000
4.389999999999950000000000000000000
4.399999999999950000000000000000000
4.409999999999950000000000000000000
4.419999999999950000000000000000000
4.429999999999950000000000000000000
4.439999999999950000000000000000000
4.449999999999950000000000000000000
4.459999999999950000000000000000000
4.469999999999950000000000000000000
4.479999999999950000000000000000000
4.489999999999950000000000000000000
4.499999999999950000000000000000000
4.509999999999950000000000000000000
4.519999999999950000000000000000000
4.529999999999950000000000000000000
4.539999999999950000000000000000000
4.549999999999950000000000000000000
4.559999999999950000000000000000000
4.569999999999950000000000000000000
4.579999999999950000000000000000000
4.589999999999950000000000000000000
4.599999999999950000000000000000000
4.609999999999950000000000000000000
4.619999999999950000000000000000000
4.629999999999950000000000000000000
4.639999999999950000000000000000000
4.649999999999950000000000000000000
4.659999999999950000000000000000000
4.669999999999940000000000000000000
4.679999999999940000000000000000000
4.689999999999940000000000000000000
4.699999999999940000000000000000000
4.709999999999940000000000000000000
4.719999999999940000000000000000000
4.729999999999940000000000000000000
4.739999999999940000000000000000000
4.749999999999940000000000000000000
4.759999999999940000000000000000000
4.769999999999940000000000000000000
4.779999999999940000000000000000000
4.789999999999940000000000000000000
4.799999999999940000000000000000000
4.809999999999940000000000000000000
4.819999999999940000000000000000000
4.829999999999940000000000000000000
4.839999999999940000000000000000000
4.849999999999940000000000000000000
4.859999999999940000000000000000000
4.869999999999940000000000000000000
4.879999999999940000000000000000000
4.889999999999940000000000000000000
4.899999999999940000000000000000000
4.909999999999940000000000000000000
4.919999999999940000000000000000000
4.929999999999940000000000000000000
4.939999999999940000000000000000000
4.949999999999940000000000000000000
4.959999999999940000000000000000000
4.969999999999940000000000000000000
4.979999999999940000000000000000000
4.989999999999940000000000000000000
4.999999999999940000000000000000000
5.009999999999940000000000000000000
5.019999999999940000000000000000000
5.029999999999940000000000000000000
5.039999999999940000000000000000000
5.049999999999940000000000000000000
5.059999999999940000000000000000000
5.069999999999940000000000000000000
5.079999999999940000000000000000000
5.089999999999940000000000000000000
5.099999999999940000000000000000000
5.109999999999940000000000000000000
5.119999999999940000000000000000000
5.129999999999940000000000000000000
5.139999999999930000000000000000000
5.149999999999930000000000000000000
5.159999999999930000000000000000000
5.169999999999930000000000000000000
5.179999999999930000000000000000000
5.189999999999930000000000000000000
5.199999999999930000000000000000000
5.209999999999930000000000000000000
5.219999999999930000000000000000000
5.229999999999930000000000000000000
5.239999999999930000000000000000000
5.249999999999930000000000000000000
5.259999999999930000000000000000000
5.269999999999930000000000000000000
5.279999999999930000000000000000000
5.289999999999930000000000000000000
5.299999999999930000000000000000000
5.309999999999930000000000000000000
5.319999999999930000000000000000000
5.329999999999930000000000000000000
5.339999999999930000000000000000000
5.349999999999930000000000000000000
5.359999999999930000000000000000000
5.369999999999930000000000000000000
5.379999999999930000000000000000000
5.389999999999930000000000000000000
5.399999999999930000000000000000000
5.409999999999930000000000000000000
5.419999999999930000000000000000000
5.429999999999930000000000000000000
5.439999999999930000000000000000000
5.449999999999930000000000000000000
5.459999999999930000000000000000000
5.469999999999930000000000000000000
5.479999999999930000000000000000000
5.489999999999930000000000000000000
5.499999999999930000000000000000000
5.509999999999930000000000000000000
5.519999999999930000000000000000000
5.529999999999930000000000000000000
5.539999999999930000000000000000000
5.549999999999930000000000000000000
5.559999999999930000000000000000000
5.569999999999930000000000000000000
5.579999999999930000000000000000000
5.589999999999930000000000000000000
5.599999999999930000000000000000000
5.609999999999920000000000000000000
5.619999999999920000000000000000000
5.629999999999920000000000000000000
5.639999999999920000000000000000000
5.649999999999920000000000000000000
5.659999999999920000000000000000000
5.669999999999920000000000000000000
5.679999999999920000000000000000000
5.689999999999920000000000000000000
5.699999999999920000000000000000000
5.709999999999920000000000000000000
5.719999999999920000000000000000000
5.729999999999920000000000000000000
5.739999999999920000000000000000000
5.749999999999920000000000000000000
5.759999999999920000000000000000000
5.769999999999920000000000000000000
5.779999999999920000000000000000000
5.789999999999920000000000000000000
5.799999999999920000000000000000000
5.809999999999920000000000000000000
5.819999999999920000000000000000000
5.829999999999920000000000000000000
5.839999999999920000000000000000000
5.849999999999920000000000000000000
5.859999999999920000000000000000000
5.869999999999920000000000000000000
5.879999999999920000000000000000000
5.889999999999920000000000000000000
5.899999999999920000000000000000000
5.909999999999920000000000000000000
5.919999999999920000000000000000000
5.929999999999920000000000000000000
5.939999999999920000000000000000000
5.949999999999920000000000000000000
5.959999999999920000000000000000000
5.969999999999920000000000000000000
5.979999999999920000000000000000000
5.989999999999920000000000000000000
5.999999999999920000000000000000000
6.009999999999920000000000000000000
6.019999999999920000000000000000000
6.029999999999920000000000000000000
6.039999999999920000000000000000000
6.049999999999920000000000000000000
6.059999999999920000000000000000000
6.069999999999920000000000000000000
6.079999999999910000000000000000000
6.089999999999910000000000000000000
6.099999999999910000000000000000000
6.109999999999910000000000000000000
6.119999999999910000000000000000000
6.129999999999910000000000000000000
6.139999999999910000000000000000000
6.149999999999910000000000000000000
6.159999999999910000000000000000000
6.169999999999910000000000000000000
6.179999999999910000000000000000000
6.189999999999910000000000000000000
6.199999999999910000000000000000000
6.209999999999910000000000000000000
6.219999999999910000000000000000000
6.229999999999910000000000000000000
6.239999999999910000000000000000000
6.249999999999910000000000000000000
6.259999999999910000000000000000000
6.269999999999910000000000000000000
6.279999999999910000000000000000000
6.289999999999910000000000000000000
6.299999999999910000000000000000000

Съдържаниет е скрито
Влезте за да го видите

Изхитрих се - написах числата от 1 до 1599 в една колона - ро лесния начин, лазбира се. В Съседна колона съставих формула, която ги разделя на 100. Така се полумат стотните, които ми трябват. Удивително е, че сега няма проблем. По-скоро удивителното е това, че при другия вариант създаваше проблеми.

Все пак, няма място за недоволство, всичко вече е наред, слава Богу.

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите

Напиши формулата =ROUND(A1+0.01;2) и я копирай.

Само че, формулата не е "=ROUND(A1+0.01;2", а "=ROUND(A1+0.01,2"

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите

При теб може и да е така, но аз използвам ";" за разделител и тези неща трябва да ги знаеш, без да правиш подобни забележки.

В отговор на:

---

При теб може и да е така, но аз използвам ";" за разделител и тези неща трябва да ги знаеш, без да правиш подобни забележки.

---

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите

Редактирано от Eжko_ на 03.03.10 16:03.

А сега и аз да се произнеса:
1. Дали е "." или "," или ";" - това зависи от кефа на М$ и от предклавиатурното как си е настроило бозата и табличката към нея.
2.Ти искаш да сравняваш две числа дали са равни?. Требе да знаеш основното правило:
Ако А и B са две числа - НИКОГА не проверявай дали А=B!!!! По правилно е да се провери дали Abs(A-B)<Epsilon , като на това Еpsilon му дадеш някоя малка стойност - напр. 0.00000001
Имал съм случаи, дето само с copy/paste и 15.00 например отива оттатъка като 15.000000000001 .... Дърт съм вече да се главоболя за причината, поради която М$ е решил да е така, та за тва...

Дано акъла ти е F1. Успех в начинанието!

Между другото, ако аз бях на твое място , щях да си направя собственно програмче, вместо да се надявам на функциите на Бате Бил (да се слави името МУ!)

Защо си мисля, че проблема е при теб my friend. Тествах със всичките числа и vlookup-а намери всичко.

В отговор на:

---

Защо си мисля, че проблема е при теб my friend. Тествах със всичките числа и vlookup-а намери всичко.

---

Съдържаниет е скрито
Влезте за да го видите

Съдържаниет е скрито
Влезте за да го видите