Search results for "Excel functions"
6 results
- Supported Excel Functions
CREATIONExcel & Sheets
This is a list of all the standard Excel functions up to Excel 365. Formulas on column "Array Enabled" mean that you can enter them inside an Array formula with a range argument (for example "if(a1:a10 < 3;…;….)") …
- Incompatible functions between Sheets and Excel
CREATIONExcel & Sheets
… app, some calculations might not be performed due to incompatibilities between Microsoft Excel and Sheets. Here's a list of functions that work in Sheets but not in Excel. ADD ARRAYFORMULA CONCAT CONTINUE COUNTUNIQUE DETECTLANGUAGE DIVIDE EQ FILTER GOOGLEFINANCE …
- Starting point Excel
CREATIONExcel & Sheets
… from TRUE to FALSE and hides the element you need to define in the spreadsheet. 2. Excel, source of truth Technically, all apps use Excel as the basis for their calculations. Even if you use a Google Sheet, we convert them into an Excel file. So if you use …
- Create an App
CREATIONBasics
In this short tutorial, you'll learn how to turn a simple Excel spreadsheet into an app. The logic from the Spreadsheet remains in the app and can be extended with additional functions. How to build a calculation app for iOS, Android, …
- Table element & data collection
CREATIONElements
A table can be a simple inventory or customer list. The logic from the Excel file is of course retained in the table element and can be extended with additional functions so that you can continue to work with calculated values line by line. In this …
- Button
CREATIONElements
… This makes it clearer for the end user what the Button does when pressed. Actions The functions described below can be selected via the drop-down 'Action' and define the functionality of the button. Jump to - Jump to a page or element within the app To switch …