Formulas: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 15: Zeile 15:
With the aggregate function, you can calculate totals that ignore hidden rows.
With the aggregate function, you can calculate totals that ignore hidden rows.


== See also ==
== See also ==
 
[[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys layout functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The StyleGuide in Excel| The StyleGuide in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Design_texts_in_Excel|Formatting functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[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}}
{{MoreContent}}
[[de:Formeln]]
[[de:Formeln]]

Version vom 3. Januar 2020, 09:26 Uhr

TBD

Formulas

RxmnuShowFormulaFormatting 16.png Formatting

Formats Excel formulas to increase readability.

RxbtnSum 16.png Total

With the total function, individual values are added.

RxbtnAggregate 16.png Aggregate

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

See also

Navigation hoch.svg The firesys layout functions in Excel
Navigation rechts.svg The StyleGuide in Excel
Navigation rechts.svg Formatting functions in Excel
Navigation rechts.svg Use Excel ranges in firesys
Navigation rechts.svg Views and comments in Excel

Further contents

firesys website
Customer area
YouTube