Feedback by UserVoice

# Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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

Signed in as (Sign out)

We’ll send you updates on this idea

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. ## Extend VLOOKUP() and HLOOKUP()

Extend the lookup functions so they can lookup left/up as well as right/down. That will save us having to build and maintain unintuitive formulae combining INDEX() and MATCH().

Signed in as (Sign out)

We’ll send you updates on this idea

We think the new XLOOKUP function is the right way to accomplish what you need here. XLOOKUP lets you specify the range to search in separately from the range that contains the value to return. For example, you can look for a value in column C, and return the corresponding value in column A or any other column.

Steve [Microsoft Excel]

3. ## 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

Signed in as (Sign out)

We’ll send you updates on this idea

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]

4. ## 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.

Signed in as (Sign out)

We’ll send you updates on this idea

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)

5. ## 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

Signed in as (Sign out)

We’ll send you updates on this idea

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]

6. ## 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

Signed in as (Sign out)

We’ll send you updates on this idea

7. ## 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.

Signed in as (Sign out)

We’ll send you updates on this idea

8. ## 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

Signed in as (Sign out)

We’ll send you updates on this idea

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

9. ## 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