Re: reikia exel formules skubiai [Pi. @ 2011-04-16 10:15:18]

Tema: Re: reikia exel formules skubiai
Autorius: Pi.
Data: 2011-04-16 10:15:18
<!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 9.00.8112.16421">
<STYLE></STYLE>
</HEAD>
<BODY>
<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></BODY></HTML>