HTML Tabelle Excel

Dieses Thema im Forum "Test Bereich" wurde erstellt von Hajo_Zi, 31 Juli 2006.

  1. Hajo_Zi

    Hajo_Zi
    Expand Collapse
    Member Deluxe

    Registriert seit:
    21 Januar 2006
    Beiträge:
    297
    Zustimmungen:
    0
    <b>NB TT 555</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:MS Sans Serif,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30; " /><col style="width:107;" /><col style="width:107;" /><col style="width:107;" /><col style="width:121;" /><col style="width:117;" /><col style="width:117;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">G</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">H</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">I</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">J</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">K</td><td style=" border-width:3px; border-style:ridge;border-color:#f0f0f0; ">L</td></tr><tr style="height:19px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >139</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; text-align:left; ">monatlicher Anteil</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="background-color:#ccffcc; font-family:Arial; font-size:11pt; ">&nbsp;</td></tr><tr style="height:19px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >140</td><td style="font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">65,48 €</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">48,18 l</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">522,3 km</td><td style="background-color:#ff00ff; font-family:Arial; font-size:11pt; text-align:right; ">9,22 l/100 km</td><td style="background-color:#00ffff; font-family:Arial; font-size:11pt; text-align:right; ">1,359</td></tr><tr style="height:20px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >141</td><td style="color:#ff0000; font-family:Arial; font-size:11pt; text-align:right; ">-20,69 €</td><td style="font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="font-family:Arial; font-size:11pt; text-align:center; ">Gutschrift</td><td style="background-color:#c0c0c0; font-family:Arial; font-size:11pt; text-align:center; ">100,00 </td><td style="background-color:#00ffff; font-family:Arial; font-size:11pt; ">&nbsp;</td></tr><tr style="height:19px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >142</td><td style="font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">68,07 €</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">52,00 l</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">452,7 km</td><td style="background-color:#ff00ff; font-family:Arial; font-size:11pt; text-align:right; ">11,49 l/100 km</td><td style="background-color:#00ffff; font-family:Arial; font-size:11pt; text-align:right; ">1,309</td></tr><tr style="height:19px ;" ><td style="border-width:3; border-style:ridge;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >143</td><td style="font-family:Arial; font-size:11pt; ">&nbsp;</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">56,81 €</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">42,75 l</td><td style="font-family:Arial; font-size:11pt; text-align:right; ">451,5 km</td><td style="background-color:#ff00ff; font-family:Arial; font-size:11pt; text-align:right; ">9,47 l/100 km</td><td style="background-color:#00ffff; font-family:Arial; font-size:11pt; text-align:right; ">1,329</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Formeln der Tabelle</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Zelle</td><td >Formel</td></tr><tr><td >K140</td><td >=WENN(ODER<span style=' color:008000; '>(I140=0;J140=0)</span>;0;<span style=' color:008000; '>(I140/<span style=' color:#0000ff; '>(J140/100)</span>)</span>)</td></tr><tr><td >L140</td><td >=RUNDEN(WENN<span style=' color:008000; '>(I140=0;0;H140/I140)</span>;3)</td></tr><tr><td >G141</td><td >=WENN(HEUTE<span style=' color:008000; '>()</span>&gt;=$A141;WENN<span style=' color:008000; '>(SUMME<span style=' color:#0000ff; '>($D$1:$G140)</span>&lt;$K141;"";-$K141-SUMME<span style=' color:#0000ff; '>(D141:F141)</span>)</span>;0)</td></tr><tr><td >K142</td><td >=WENN(ODER<span style=' color:008000; '>(I142=0;J142=0)</span>;0;<span style=' color:008000; '>(I142/<span style=' color:#0000ff; '>(J142/100)</span>)</span>)</td></tr><tr><td >L142</td><td >=RUNDEN(WENN<span style=' color:008000; '>(I142=0;0;H142/I142)</span>;3)</td></tr><tr><td >K143</td><td >=WENN(ODER<span style=' color:008000; '>(I143=0;J143=0)</span>;0;<span style=' color:008000; '>(I143/<span style=' color:#0000ff; '>(J143/100)</span>)</span>)</td></tr><tr><td >L143</td><td >=RUNDEN(WENN<span style=' color:008000; '>(I143=0;0;H143/I143)</span>;3)</td></tr></table></td></tr></table> <span style="font-family:Arial; font-size:9pt;font-weight:bold; ">Excel Tabellen im Web darstellen&nbsp;&nbsp;<a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#1506f7; font-weight:bold;" href="http://www.haserodt.de/ejh_do/ex_jean_info.htm" target="_blank">Excel Jeanie HTML</a></span>
     
  2. dalex

    dalex
    Expand Collapse
    Member Deluxe

    Registriert seit:
    28 November 2001
    Beiträge:
    1.191
    Zustimmungen:
    0
    Äh,
    was willst du uns damit sagen? Wenn ich den HTML-Code kopiere und als HTML-Datei speichere kommen zwei Tabellen raus.

    Gruß dalex
     
  3. NightwoLF

    NightwoLF
    Expand Collapse
    <font color="#FF0000">S-Moderator</font><br><img s

    Registriert seit:
    8 September 2000
    Beiträge:
    352
    Zustimmungen:
    0
    @dalex

    hat schon alles seine richtigkeit
     
  4. Hajo_Zi

    Hajo_Zi
    Expand Collapse
    Member Deluxe

    Registriert seit:
    21 Januar 2006
    Beiträge:
    297
    Zustimmungen:
    0
    #4 Hajo_Zi, 1 August 2006
    Zuletzt bearbeitet: 26 September 2007
Die Seite wird geladen...

Diese Seite empfehlen