Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. VBA formulas same as excel formulas

    I would like to see the abiltiy to use any excel formula used in VBA, with the same syntax.

    For example-Range("A1").value = ExcelFormula.=countif(B2:B30),testing

    Something like that to signfiy to vba that an excel formula in the exact same way that it is used in VBA, so you could even cut and paste any formula between excel and VBA.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    We have no plans to structurally update the VBA environment (see “Bring VBA into the modern world”). However, you can work with Excel functions in VBA already, using the WorkbookFunction object. The syntax is still VBA-like instead of Excel-like, but the functionality is there.

    Alternatively, you can use Evaluate, as Kenneth suggested:
    Dim x As Double
    x = Evaluate(”SUM(A1,A2)”) ‘Evaluate function
    x = [SUM] ‘Shortcut

    Cheers,
    Dan [MS]

  2. numbers and not formulas in the cell

    in a formula, add the possibility to write a symbol after = to say that you want to write just the result, and not the formula, in the cell

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Formulas are a key part of Excel, so we won’t be auto-converting them to values on entry. However, you can convert them to values by selecting the cell after you’ve entered the formula and copying it (Ctrl+C); then Paste Special (Ctrl+Alt+V) and choose Values.

    That will leave the number in the cell, rather than leaving the formula there.

    Cheers,
    Dan [MS]

  3. If statement consistent formulas

    How IF statements currently work:
    A1=3; B1=2; C1=1;
    IF(A1>B1>C1, "True", "False") Results: True
    IF(C1<B1<A1, "True", "False") Results: False

    Both these statements should be true, but the second one gives the wrong results. For situations like this the logic statements are only correct if the > symbol is used; otherwise the true and false statements get flipped.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Given the way Excel evaluates formulas, which is from left to right, this isn’t going to change. Here’s what happens:

    IF (C1<B1<A1, “True”, “False”)
    IF (1<2<A1, “True”, “False”)
    IF (TRUE<3, “True”, “False”) <— you can see how the next check will fail (be false)
    IF (FALSE, “True”, “False”)
    “False”

    The way to write this function so that Excel will do the right thing is:

    IF (AND (C1<B1, B1<A1), TRUE, FALSE)

    Hope that helps,
    Dan [MS]

    (sorry for the wonky formatting, apparently there’s some UserVoice markup I have to work around)

  4. Add a function returning the corresponding quadrant to a specific angle.

    Add a function returning the corresponding quadrant (1, 2, 3 or 4) to a specific angle. Preferrable with the option to choose input angle in degrees or radians.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    We are unlikely to add a specialized function for this, but the great thing about Excel is that formulas allow you to build this function already. As Kenneth explained in the comments, you can do this today with existing functions (I can’t copy them here due to some we’re UserVoice formatting with the MOD function)

    Hope that helps,
    Dan [MS]

  5. Argument consistency between vlookup and match

    When you try to explain how the VLOOKUP formula works to users the last argument asks for either True or False. However, when you use the MATCH formula the last argument asks for -1, 0 or 1.

    Can we align the logic? Also, 99% of the time people are looking for an exact match so can you please make that the default when omitted?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    declined  ·  1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Merge COUNTIF and COUNTIFS

    COUNTIFS can do exactly what COUNTIF does and more. The only disadvantages are writing the extra "S" and possibly a negligible hit in performance due to COUNTIFS using variable-length argument lists. My suggestion is to make COUNTIF work like COUNTIFS and make COUNTIFS a compatibility function.

    I can't say the same for SUMIF and AVERAGEIF, since these functions allow the omission of their last argument, which can be a nice perk over their -IFS counterparts on the (very) rare occasion.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    declined  ·  1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. INFLATION and CONVERTCURRENCY functions

    These 2 functions would make accounting on the international level much simpler.
    -INFLATION converts a currency to its value at a different time.
    -CONVERTCURRENCY converts a currency to another currency based on the exchange rate at a given time.

    The syntaxes would thus look something like this:
    INFLATION(value, ISO 4217 code, from datetime, to datetime)
    CONVERTCURRENCY(value, datetime, from ISO 4217 code, to ISO 4217 code)

    Of course, this would require Excel to either come packaged with or connect to the Internet to obtain a complete history of exchange rates, but this is much easier than having the users continuously get…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  Jeff Zhang (MSFT) responded

    Dear Excel User

    Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important. :)

    Thanks,
    Microsoft Excel Team

  8. fix max function to not error when seeing errors

    I have to include errors in the data so that it will not plot in a chart. However I also want to get Min, Max, Average, etc, but all these will return errors because the data has errors. Can this be fixed so that any errors are ignored, especially with Min and Max.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    declined  ·  1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base