Formulas: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
<imagemap>Datei:EN Excel Gestaltung Formeln.jpg|center|1200px|center| | <imagemap>Datei:EN Excel Gestaltung Formeln.jpg|center|1200px|center| | ||
rect 3 75 200 187 [[ | rect 3 75 200 187 [[The_basic_functions_of_firesys]] | ||
rect 288 77 463 182 [[ | rect 288 77 463 182 [[Design_texts_in_Excel]] | ||
rect 204 76 285 184 [[ | rect 204 76 285 184 [[The_StyleGuide_in_Excel]] | ||
rect 464 74 541 180 [[ | rect 464 74 541 180 [[Design_texts_in_Excel#Highlighting]] | ||
rect 545 73 643 183 [[ | rect 545 73 643 183 [[Design_texts_in_Excel#Conditional_formatting]] | ||
rect 650 75 914 187 [[Excel- | rect 650 75 914 187 [[Excel-areas]] | ||
rect 1110 75 1572 187 [[ | rect 1110 75 1572 187 [[Views_and_comments_in_Excel]] | ||
desc none | desc none | ||
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) --> | #<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) --> | ||
Version vom 6. Januar 2020, 09:00 Uhr
<imagemap>Datei:EN Excel Gestaltung Formeln.jpg|center|1200px|center| rect 3 75 200 187 The_basic_functions_of_firesys rect 288 77 463 182 Design_texts_in_Excel rect 204 76 285 184 The_StyleGuide_in_Excel rect 464 74 541 180 Design_texts_in_Excel#Highlighting rect 545 73 643 183 Design_texts_in_Excel#Conditional_formatting rect 650 75 914 187 Excel-areas rect 1110 75 1572 187 Views_and_comments_in_Excel desc none
</imagemap>
Formulas
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.
See also
The firesys layout functions in Excel
The StyleGuide in Excel
Formatting functions in Excel
Use Excel ranges in firesys
Views and comments in Excel