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 inapp 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 thirdparty 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.

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 exampleRange("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 voteHi,
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 VBAlike instead of Excellike, 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] ‘ShortcutCheers,
Dan [MS] 
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 voteFormulas are a key part of Excel, so we won’t be autoconverting 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] 
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: FalseBoth 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 votesGiven 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)

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 voteWe 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] 
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 
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 variablelength 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 
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 voteDear 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 
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
 Don't see your idea?