PDA

Vollständige Version anzeigen : Minus und plus rechnen mit leeren Zellen


Rotzbaengel
26.03.2012, 23:23
Hallo,

ich hab wieder ein problem :(

in der bsp datei hab ich mal was fix zusammgestellt. Also es wird ein Anfangswert per hand eingeschrieben dann sollen verschieden werte abgezogen bzw dazugerechnet werden. in meiner eigentlichen tabelle habe ich aber bis zu 3 leere zellen dazwischen. ich wollte das der saldo nicht in den leeren zellen steht sondern nix. hab es mit der formel =WENN(A2>0;B1-B3;"") versucht. aber spätestestens nach der 2. leeren zelle kommt dann #wert :boah:

Wie muss ich die formel verändern das die leere zelle sozusagen übersprungen wird bzw halt mit null gerechnet wird auch wenn nix in der zelle steht.

mfg rotzbaengel

Erich G.
26.03.2012, 23:39
Hi,
D3 kannst du nach unten kopieren:

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:63px;" /><col style="width:74px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; text-align:center; ">Saldo</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1500</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">100</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1600</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">200</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1800</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">15</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1785</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">25</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1740</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">50</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1790</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1770</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">30</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1740</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1720</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 >D3</td><td >=WENN(B3="";"";D$2+SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(B$3:B3="einnahme")</span>*C$3:C3)</span>-SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(B$3:B3="ausgabe")</span>*C$3:C3)</span>)</td></tr><tr><td >D4</td><td >=WENN(B4="";"";D$2+SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(B$3:B4="einnahme")</span>*C$3:C4)</span>-SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(B$3:B4="ausgabe")</span>*C$3:C4)</span>)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel Tabellen im Web darstellen &gt;&gt; </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4 </a>

So gehts auch - etwas kürzer:

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:63px;" /><col style="width:74px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; text-align:center; ">Saldo</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1500</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">100</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1600</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">200</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1800</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">15</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1785</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">25</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1740</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">50</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1790</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1770</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">30</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1740</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">20</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1720</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 >D3</td><td >=WENN(B3="";"";D$2+SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(1-2*<span style=' color:#ff0000; '>(B$3:B3="ausgabe")</span>)</span>*C$3:C3)</span>)</td></tr><tr><td >D4</td><td >=WENN(B4="";"";D$2+SUMMENPRODUKT<span style=' color:008000; '>(<span style=' color:#0000ff; '>(1-2*<span style=' color:#ff0000; '>(B$3:B4="ausgabe")</span>)</span>*C$3:C4)</span>)</td></tr></table></td></tr></table>
Und noch eine Version ohne SUMMENPRODUKT:

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:63px;" /><col style="width:74px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; ">&nbsp;</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1500</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">100</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1600</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Arial; font-size:10pt; ">einnahme</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">200</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1800</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:Arial; font-size:10pt; ">ausgabe</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">15</td><td style="font-family:Arial; font-size:10pt; text-align:right; ">1785</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 >D3</td><td >=WENN(B3="";"";D$2+SUMMEWENN<span style=' color:008000; '>(B$3:B3;"einnahme";C$3:C3)</span>-SUMMEWENN<span style=' color:008000; '>(B$3:B3;"ausgabe";C$3:C3)</span>)</td></tr><tr><td >D4</td><td >=WENN(B4="";"";D$2+SUMMEWENN<span style=' color:008000; '>(B$3:B4;"einnahme";C$3:C4)</span>-SUMMEWENN<span style=' color:008000; '>(B$3:B4;"ausgabe";C$3:C4)</span>)</td></tr></table></td></tr></table>

zra8886
27.03.2012, 06:48
Hallo ???,

das muss man nicht so kompliziert aufbauen. Da gehört etwas Ordnung rein.

Eine Spalte Einnahmen und eine Spalte Ausgaben, sowie es in einer Buchführung ganz normal ist:
<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:97px;" /><col style="width:97px;" /><col style="width:97px;" /><col style="width:119px;" /><col style="width:97px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">18</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Einnahme</td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Ausgabe</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Anfangssaldo</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1500</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">19</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >100</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >15</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Einnahmen</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >350</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">20</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >200</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >20</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Ausgaben</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >110</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">21</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >50</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >25</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:left; " >Endsaldo</td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >1740</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">22</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >20</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">23</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; text-align:right; " >30</td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>F19 </td><td>=SUMME(B19:B23)</td><td>&nbsp;</td></tr><tr><td>F20 </td><td>=SUMME(C19:C23)</td><td>&nbsp;</td></tr><tr><td>F21 </td><td>=F18+F19-F20</td><td>&nbsp;</td></tr></table><br/><a href="http://c.excelhost.de/c_beverly/getfile.php?id=122" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.42</a><br/><br/>
mfg
Roland

Erich G.
27.03.2012, 07:30
Hi,
da gibt es Alternativen zur immer wiederkehrenden Summiererei, z. B.

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:90px;" /><col style="width:74px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >&nbsp;</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >&nbsp;</td><td style="text-align:center; ">Umsatz</td><td style="text-align:center; ">Saldo</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">Startwert</td><td >&nbsp;</td><td style="text-align:right; ">1500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >einnahme</td><td style="text-align:right; ">100</td><td style="background-color:#99cc00; text-align:right; ">1600</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >einnahme</td><td style="text-align:right; ">200</td><td style="text-align:right; ">1800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >ausgabe</td><td style="text-align:right; ">15</td><td style="text-align:right; ">1785</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >ausgabe</td><td style="text-align:right; ">20</td><td style="text-align:right; ">1765</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >ausgabe</td><td style="text-align:right; ">25</td><td style="text-align:right; ">1740</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >einnahme</td><td style="text-align:right; ">50</td><td style="text-align:right; ">1790</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >ausgabe</td><td style="text-align:right; ">20</td><td style="text-align:right; ">1770</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >ausgabe</td><td style="text-align:right; ">30</td><td style="text-align:right; ">1740</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >&nbsp;</td><td style="text-align:right; ">7777777</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >&nbsp;</td><td >&nbsp;</td><td >&nbsp;</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >ausgabe</td><td style="text-align:right; ">20</td><td style="text-align:right; ">1720</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 >D3</td><td >=WENN(B3="";"";VERWEIS<span style=' color:008000; '>(1E+307;D$2:D2)</span>+<span style=' color:008000; '>(1-2*<span style=' color:#0000ff; '>(B3="ausgabe")</span>)</span>*C3)</td></tr></table></td></tr></table>

@Roland:
Ich denke auch, dass deine Lösung in den meisten Fällen geschickter ist.
Aber vielleicht wird hier ja der Saldoverlauf benötigt,
oder die Einnahmen und Ausgaben kommen in der hier dargestellten Form angelaufen...

zra8886
27.03.2012, 07:45
Moin Erich,
...oder die Einnahmen und Ausgaben kommen in der hier dargestellten Form angelaufen...

Das heisst aber nicht, dass man so eine Unübersichtlichkeit beibehalten muss.

Optimierung der Darstellung = einfachere Übersicht und auch einfachere Dateneingabe.

Tabellenblatt 1: Übersicht
Tabellenblatt 2: Einnahmen und Ausgaben

oder auch

Tabellenblatt 1: Übersicht
Tabellenblatt 2: Einnahmen
Tabellenblatt 3: Ausgaben

wäre für eine übersichtliche Darstellung mein Vorgehen.

...Aber vielleicht wird hier ja der Saldoverlauf benötigt,...

Da stellt sich die Frage, für was das gut sein soll. Ich selbst sehe da keinen Sinn darin. Da sollte sich der TS mal darüber äußern.

mfg
Roland