Blog Post

Excel Blog
1 MIN READ

Formula Argument Assistance

Inbar_Privman's avatar
Inbar_Privman
Icon for Microsoft rankMicrosoft
Mar 20, 2023

We have added a Formula Argument Assistance card to Excel Web!

Formula Argument Assistance card accompanies you while writing a formula, and helps you insert or edit the arguments.

You no longer need to reach out to external sources for help when you are typing your formula! The Argument Assistance card will help you write formulas more efficiently and reduce errors.

 

About the feature

The Argument Assistance card provides descriptions of the function and the different arguments, as well as an example:

The card includes formula and arguments descriptions, and an example.

 

For better orientation, the relevant argument is highlighted during formula editing:

The relevant argument is highlighted.

 

The card can be collapsed and expanded. You can collapse the card and display only the formula signature if you don't want to hide much of the grid:

The card can be collapsed or expanded.

 

For convenience, the card can be dragged and moved around the screen:

The card can be dragged around the screen.

 

How does it work?

Start typing a formula in a cell or in the formula bar. After writing the formula name and the opening parenthesis, the card will appear.

For example:=VLOOKUP(

OR choose a function from the Insert Function dialog OR from the dropdown menus in the Formulas tab.

Card appears after opening parenthesis.

 

Feedback

We hope you like this new addition to Excel Web and we’d love to hear what you think about it!

Please share your feedback with us by clicking the Give Feedback button that can be found at the bottom of the card.

Share your feedback.

 

Availability

Currently, Argument Assistance is available in Excel for the Web. In the future, this feature will be added to Excel desktop versions as well.

Updated Mar 20, 2023
Version 1.0
Argument Assistance
Arguments
assistance
Blog
excel
Excel Formula
  • GabrM's avatar
    GabrM
    Brass Contributor
    Dec 27, 2023

    Sign me up for the desktop version as well, on top of custom functions support!!!

  • Rasha369's avatar
    Rasha369
    Copper Contributor
    Oct 11, 2023

    how can i write separate column för weekday name ? 

  • bbotz's avatar
    bbotz
    Copper Contributor
    Sep 18, 2023

    Add to DESKTOP version!!! Online version has limited functionality...

  • TWEagle's avatar
    TWEagle
    Copper Contributor
    Mar 30, 2023

    Cool thing, but does it also come for the desktop version?

  • lori_m's avatar
    lori_m
    Steel Contributor
    Mar 26, 2023

    Inbar_Privman

    This is a great addition for general users. It'd also be really helpful if additional guidance was available on DA evaluation, which can be confusing at times, including function signature details and improved formula tools. Taking MATCH as an example, the following formula returns a single value result when one might expect an array:
    =MATCH(A1,B1:B5,C1:C2)
    Stepping through Evaluate Formula with suitable inputs shows the third argument seems to be passed as a range and in order to return an array the range needs to be converted to an array explicitly: +C1:C2. On the other hand if the first argument is changed to A1:A2 stepping through the evaluation appears to show the conversion from range to array is implicit - presumably as the range is passed as values. It'd be nice if this was all made more transparent...

  • Inbar_Privman's avatar
    Inbar_Privman
    Icon for Microsoft rankMicrosoft
    Mar 26, 2023

    Hi GabrM, 

    Supporting custom functions is on our backlog, but unfortunately, we don't have a solid timeline for it yet.
    I encourage you to follow the announcements of this portal for upcoming updates.

     

    Best,

    Inbar

  • sanjibdutta's avatar
    sanjibdutta
    Brass Contributor
    Mar 24, 2023

    Excellent addition! I think Name Manager dialogue must be redesigned to support for providing structured documentation (Arguments assistant card) for a Lambda function. Or at least a field to refer to a local file that contains structured documenetation. Very excited to see all these in action. Excel is becoming a fun place to work with..Thank you team!