Compare REGISTER.ID vs FORECAST
2 vsCompare REGISTER.ID vs FORECAST side-by-side — differences, popularity and recommendation
Presets:
VLOOKUP vs XLOOKUP
SUM vs SUMIFS
INDEX vs MATCH vs XLOOKUP
IF vs IFS vs SWITCH
COUNT vs COUNTA vs COUNTIF
AVERAGE vs AVERAGEIF vs AVERAGEIFS
MAX vs LARGE vs MIN
TEXT vs TEXTJOIN vs CONCAT
FILTER vs SORT vs UNIQUE
ROUND vs ROUNDUP vs ROUNDDOWN
All functions
Pick at least 2 functions
Feature
Category
Compatibility compatibility
Compatibility compatibility
Popularity
12 / 100
35 / 100
Views
◉ 29 views
◉ 56 views
Output
Number
Number
Version
Excel 2007 (Compatibility)
All versions
Volatile
No
No
Dynamic Array
No
No
Description
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID. For more information about DLLs and code resources and data types, see Using the CALL and REGISTER functions.
Predicts a future value based on a linear trend (the legacy FORECAST.LINEAR)
Syntax
=REGISTER.ID(module_text,procedure,[type_text])=FORECAST(x, known_y's, known_x's)Arguments
3 Arguments
module_text
procedure
type_text (Optional)
3 Arguments
x
known_y's
known_x's
Examples
1
2
Tips
1
3
★ Recommendation — Winner: =FORECAST()
=FORECAST() is recommended based on higher popularity, newer version and Dynamic Array support.