The validation basic functions: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 89: Zeile 89:


{{MoreContent}}
{{MoreContent}}
[[Kategorie:Excel Dokument-Validierungen-Übersicht]]
[[Kategorie:English-Excel Dokument-Validierungen-Übersicht]]

Version vom 6. Januar 2020, 11:31 Uhr

<imagemap>Datei:Excel-Validierung-Menüband-Grundfunktionen.jpg|center rect 2 78 215 197 Die_Basisfunktionen_von_firesys rect 328 84 785 202 Dateiübergreifende_Validierungen rect 224 83 325 200 Die_Kontenmappe rect 791 86 1063 199 Das_Validierungsblatt rect 1069 88 1387 200 Der_Zentralwert-Manager

rect 215 81 317 194 Validierung_bearbeiten rect 323 80 403 195 Validierungen_erstellen rect 409 80 484 192 Validierung_bearbeiten rect 488 82 565 190 Validierung_löschen rect 574 81 757 110 Abweichungen_freigeben rect 580 116 755 144 Abweichungen_freigeben desc none

</imagemap>



Excel Funktionen 64.png
The validation basic functions

You can (automatically) compare two or more numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.

Excel Funktionen 64.png

With the help of a single validation you can create a new validation whereby two individual values are related to each other. more



With the help of a multiple validation you can create a new validation whereby you can summarise several values in formulas. This enables you to validate related values in one step. more


With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. more


When you process a validation, you can change the selected validation and also edit the comment or the designation. more



You can delete validations that were created. Multiple selection is also possible here. more



Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the validation sheet nor are they marked as errors in the Word tables. more


See also

Navigation hoch.svg An overview of all validation functions in Excel
Navigation rechts.svg The master value manager
Navigation rechts.svg The firesys account workbook
Navigation rechts.svg The firesys validation worksheet

Further contents

firesys website
Customer area
YouTube