microsoft
[Bug?] Incorrect argument names shown for some native Excel formulas
Hello! I noticed when auditing a formula that the argument or parameter names for the ADDRESS formula are wrong in the AFE. Haven't yet noticed similar errors with other native Excel formulas.
Microsoft® Excel® for Microsoft 365 MSO (Version 2407 Build 16.0.17730.20000) 64-bit
As always, thank you!
Didn't catch. Till we add parameters any function is highlighted with error.
Didn't catch. Till we add parameters any function is highlighted with error.
Sorry for being unclear. As you can see in the formula bar screenshot, the first three args of ADDRESS are row_num, column_num, [abs_num]. Yet as seen in the AFE screenshot, AFE shows them as number, number, [number]. Then [a1] shows as [boolean].
Actually, knowing the expected types is useful, but the argument names need to be shown. Then I propose something like [a1:boolean].
This is a 'bug', or rather, I did not add the specific argument names for all functions (only common ones). However, I have since tracked down where I can find them all, so hopefully can update this.
