Copyright 2003-2026 Bug & dizzy.hr30Sat, 16 May 2026 01:47:35 GMTpisma@bug.hrhrMon, 24 Oct 2016 21:44:13 GMTTema unutar podforuma Uredski alatiExcel - formula zaokruzivanje ali ne matematickohttp://bugforum.azurewebsites.net/forum/topic/uredski-alati/excel-formula-zaokruzivanje-ne-matematicko/244569.aspxhttp://www.bug.hr/images/forum-rss.gifRe: Excel - formula zaokruzivanje ali ne matematic=IF(RIGHT(ROUNDDOWN(A1;);1)>"5";LEFT(ROUNDDOWN(A1;);LEN(ROUNDDOWN(A1;))-1)&"8,00";LEFT(ROUNDDOWN(A1;);LEN(ROUNDDOWN(A1;))-1)&"3,00") http://bugforum.azurewebsites.net/forum/post/uredski-alati/excel-formula-zaokruzivanje-ne-matematicko/5197439.aspxMon, 24 Oct 2016 21:44:13 GMTd0701c56c08c5beb51b75dcaea1fd6efExcel - formula zaokruzivanje ali ne matematickoPozdrav Molim savjet za Excel formulu koja bi "zaokruzivala" po slijedecem princip Ako je rezultat broj koji zavrsava (zadnja znamenka jedinica) 0,1,2,3,4,5 onda mu zadnja znamenka nakon zao...http://bugforum.azurewebsites.net/forum/post/uredski-alati/excel-formula-zaokruzivanje-ne-matematicko/5197387.aspxMon, 24 Oct 2016 20:37:30 GMT6bfd26198d379673947a40c0764d243e