Re: reikia exel formules skubiai [Nikodemas @ 2011-04-16 11:03:56]

Tema: Re: reikia exel formules skubiai
Autorius: Nikodemas
Data: 2011-04-16 11:03:56
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1257" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19046">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Ai!! :)</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV>"Pi." &lt;<A 
  href="mailto:juobar@googlomailas.com">juobar@googlomailas.com</A>&gt; wrote in 
  message <A 
  href="news:iobfm6$28q$1@trimpas.omnitel.net">news:iobfm6$28q$1@trimpas.omnitel.net</A>...</DIV>
  <DIV>
  <TABLE style="WIDTH: 285pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 
  cellPadding=0 width=380>
    <COLGROUP><FONT face=Arial>
    <COL style="WIDTH: 48pt" width=64>
    <COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" 
    width=88>
    <COL style="WIDTH: 48pt" width=64>
    <COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3657" 
    width=100>
    <COL style="WIDTH: 48pt" width=64><FONT size=2></FONT></FONT>
    <TBODY>
    <TR style="HEIGHT: 15pt" height=20>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 height=20 width=64><FONT size=2 face=Arial>turi</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 width=88><FONT size=2 face=Arial>reikia be pvm</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 width=64><FONT size=2 face=Arial>pvm%</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 width=100><FONT size=2 face=Arial>pvm suma</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 width=64><FONT face=Arial><FONT size=2><SPAN 
        style="mso-spacerun: yes">&nbsp;</SPAN>viso</FONT></FONT></TD></TR>
    <TR style="HEIGHT: 15pt" height=20>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 height=20 align=right><FONT size=2 face=Arial>5</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>4,13</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl67 align=right><FONT size=2 face=Arial>21</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>0,87</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>5,00</FONT></TD></TR>
    <TR style="HEIGHT: 15pt" height=20>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 height=20 align=right><FONT size=2 face=Arial>100</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>82,64</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 align=right><FONT size=2 face=Arial>21</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>17,36</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>100,00</FONT></TD></TR>
    <TR style="HEIGHT: 15pt" height=20>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 height=20 align=right><FONT size=2 face=Arial>55</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>52,38</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl65 align=right><FONT size=2 face=Arial>5</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 face=Arial>2,62</FONT></TD>
      <TD 
      style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" 
      class=xl66 align=right><FONT size=2 
  face=Arial>55,00</FONT></TD></TR></TBODY></TABLE></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial></FONT><FONT size=2 
face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>&nbsp;be pvm =A2/(1+C2/100)<BR>pvm suma 
  =A2-B2<BR>viso =D2+B2<BR></FONT></DIV>
  <DIV><FONT size=2 face=Arial>"Pi." &lt;</FONT><A 
  href="mailto:juobar@googlomailas.com"><FONT size=2 
  face=Arial>juobar@googlomailas.com</FONT></A><FONT size=2 face=Arial>&gt; 
  wrote in message </FONT><A href="news:iobeub$1kg$1@trimpas.omnitel.net"><FONT 
  size=2 face=Arial>news:iobeub$1kg$1@trimpas.omnitel.net</FONT></A><FONT size=2 
  face=Arial>...</FONT></DIV><FONT size=2 face=Arial>&gt;o tai 21% 
  visada?<BR>&gt; tai dalini 5 is 1.21 ir turi be pvm<BR>&gt; <BR>&gt; 
  "Nikodemas" &lt;</FONT><A href="mailto:niko@demas.lt"><FONT size=2 
  face=Arial>niko@demas.lt</FONT></A><FONT size=2 face=Arial>&gt; wrote in 
  message <BR>&gt; </FONT><A href="news:iobehr$182$1@trimpas.omnitel.net"><FONT 
  size=2 face=Arial>news:iobehr$182$1@trimpas.omnitel.net</FONT></A><FONT size=2 
  face=Arial>...<BR>&gt;&gt; ne, ne taip<BR>&gt;&gt;<BR>&gt;&gt; a turiu 
  5,<BR>&gt;&gt; reikia 4,13 + 21% = 5<BR>&gt;&gt;<BR>&gt;&gt; "Nikodemas" 
  &lt;</FONT><A href="mailto:niko@demas.lt"><FONT size=2 
  face=Arial>niko@demas.lt</FONT></A><FONT size=2 face=Arial>&gt; wrote in 
  message <BR>&gt;&gt; </FONT><A 
  href="news:iobdoi$c1$1@trimpas.omnitel.net"><FONT size=2 
  face=Arial>news:iobdoi$c1$1@trimpas.omnitel.net</FONT></A><FONT size=2 
  face=Arial>...<BR>&gt;&gt;&gt; nesigalvoja etadien i ryto.<BR>&gt;&gt;&gt; 
  reikia formuls atimti procent: tipo 5 - 21% = 4.13<BR>&gt;&gt;&gt; kaip 
  formul sudlioti, nes daug skaii?<BR>&gt;&gt;&gt;<BR>&gt;&gt;<BR>&gt;&gt; 
  <BR>&gt;</FONT> </BLOCKQUOTE></BODY></HTML>