April 7, 2026
Greater control and error visibility for Google Sheets formulas
We are introducing updates to the logic and parameter support for a targeted set of Google Sheets functions. These changes are designed to improve error visibility, offer more control over data, and ensure seamless compatibility when importing files.
Specifically, you will notice improvements across several categories of functions, including:
- Better error surfacing: Select informational and statistical functions (such as HYPERLINK, VALUE, and T.TEST) will now more accurately flag underlying errors, like broken URLs or zero-variance denominators, preventing potential data issues from being masked.
- Enhanced parameter support: Several statistical distribution functions (such as HYPGEOM.DIST, NORM.S.DIST, and LOGNORM.DIST) now support additional parameters, allowing for greater control and ensuring they import smoothly from external spreadsheets.
- Refined calculation logic: Select financial and array functions (such as CUMIPMT and FREQUENCY) have been updated to provide more precise and predictable results based on your specific data inputs.
These enhancements reduce friction and provide more trustworthy outcomes for users who rely on precise mathematical behaviors. You can now troubleshoot complex spreadsheets more effectively and import external files with confidence, knowing your formulas will evaluate as expected. For a comprehensive list of Sheets functions and their specific inputs and behavior, please visit our Help Center.
Getting started
- Admins: There is no admin control for this feature.
- End users: There is no end user setting for this feature. Visit the Help Center to learn more about how these functions work in Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Available now
Availability
- Google Workspace customers and users with personal Google accounts
Resources
- Google Help: Google Sheets function list