Formula Assistant
This feature helps users find and create Excel formulas, whether simple or complex, through a search interface and guided process.
It is accessed from the EasySheet Pro ribbon and opens a dedicated form.
Notes
Search is case-insensitive
Supports partial term searches
Complex formulas have a dedicated guided process
The formula database includes examples and detailed descriptions
Formulas are inserted in the correct format for Excel
If no results are found, the system suggests: Using simpler terms, Checking spelling, Trying different keywords.
Available Operations
Search field with real-time results
List of found formulas with descriptions
Support for multi-word search
Displays all available formulas when the search field is empty
How to Use
Click on the desired formula from the list
A series of dialog boxes guides you through parameter selection
Contextual suggestions are provided
Select the target cell
The system automatically inserts the formula into the chosen cell