All CollectionsCalculationsSpreadsheetFormulas in SpreadsheetFormulas in SpreadsheetUse functions to build custom calculationsBy Holly1 author·5 articlesBuilding a Formula in SpreadsheetWriting a GI.* formula, pointing at cells, and worked examples: plot ratio, efficiency, blended revenue, unit mix, residual land value, cashflowFilters in SpreadsheetThe filter argument, its operators, and taking a filter value from a cell with GI.WHEREUnits in SpreadsheetThe metric/imperial toolbar control, how conversion works, and GI.UNITS()Per-Geometry Calculations in SpreadsheetGI.SUMEACH and its relatives, why a missing field is skipped not zero, measure classes, and weighted averagesFunction List in SpreadsheetEvery function, its arguments defined, a worked example, and a real estate reason to use it