by Ilker | Nov 22, 2022 | Excel Formulas
The TEXTAFTER function is a Text function that returns part after a given character or string. In this guide, we’re going to show you how to use the TEXTAFTER function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider Beta...
by Ilker | Aug 18, 2022 | Excel Formulas
In Excel, The DEGREES function is a Math & Trigonometry function that converts radians into degrees. In this guide, we’re going to show you how to use the DEGREES function and go over some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Aug 17, 2022 | Excel Formulas
In Excel, The RADIANS is a Math & Trigonometry function that converts degrees into radians. In this guide, we’re going to show you how to use the RADIANS function and go over some tips and error handling methods. Supported versions All versions Syntax...
by Ilker | Aug 11, 2022 | Blog
SpreadsheetWeb Hub supports Excel's LAMBDA function. Recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of LAMBDA function. In this article, we will build a function to calculate distance...
by Ilker | Jul 6, 2022 | Excel Tips & Tricks
In this guide, we’re going to show you How to display negative numbers as zero in Excel in two ways. Download-Workbook Formula approach to display negative numbers as zero The first method in our list is the formula way. An obvious way is to use the IF function which...
by Ilker | Apr 12, 2022 | Excel Formulas
TREND The TREND function is a Statistical function that can return values along a linear trend line through a given set of dependent and, optionally, independent values. In this guide, we’re going to show you how to use the TREND function and go over some tips and...
by Ilker | Mar 8, 2022 | Excel Formulas
The FORECAST.ETS.STAT function is a Statistical function that returns a statistical information based on time series forecasting. This function can be used with FORECAST.ETS function to see the statistical values of forecasting. In this guide, we’re going to show you...
by Ilker | Mar 4, 2022 | Excel Formulas
The FORECAST.ETS.CONFINT function is a Statistical function that calculates a confidence interval for a forecasted value by using existing values with a seasonal pattern. The function is using the AAA version (additive error, additive trend and additive seasonality)...
by Ilker | Mar 3, 2022 | Excel Tips & Tricks
The FORECAST.ETS.SEASONALITY function is a Statistical function that predicts the length of the season in a repetitive pattern, for a given specified time series. The function returns the same season length which is calculated by the FORECAST.ETS function...