Formulas: Unterschied zwischen den Versionen

Aktuelle Version vom 19. November 2021, 12:14 Uhr

Formats Excel formulas to increase readability.

With the total function, individual values are added.

With the aggregate function, you can calculate totals that ignore hidden rows.

@@ Zeile 1: / Zeile 1: @@
-TBD
+[[Datei:EN_Menüband_Excel_Gestaltung_Formeln.jpg|center|1200px]]
-Formatting	Formats Excel formulas to increase readability.
-Total	With the total function, individual values are added.
-Aggregate	With the aggregate function, you can calculate totals that ignore hidden rows.
+== Formulas ==
+=== [[Datei:rxmnuShowFormulaFormatting_16.png|link=|16px]] Formatting	===
+Formats Excel formulas to increase readability.
+=== [[Datei:rxbtnSum_16.png|link=|16px]] Total	===
+With the total function, individual values are added.
+=== [[Datei:rxbtnAggregate_16.png|link=|16px]] Aggregate ===
+With the aggregate function, you can calculate totals that ignore hidden rows.
+== See also  ==
+[[Datei:Navigation_hoch.svg|link=]] [[Design_an_Excel_document|Design an Excel document]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[The StyleGuide in Excel| The StyleGuide in Excel]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Design_texts_in_Excel|Design texts in Excel | Formatting functions in Excel]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Excel-areas|Excel-areas | Use Excel ranges in firesys]] <br>
+[[Datei:Navigation_rechts.svg|link=]] [[Views_and_comments_in_Excel|Views and comments in Excel]]   <br>
+{{MoreContent}}
+[[de:Formeln]]
+[[Kategorie:English-Excel Dokument-gestalten-Übersicht]]