Sergei Baklan
My feedback

8 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan supported this idea ·

6 votes4 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan supported this idea ·

1 vote

1 voteSergei Baklan commented
That is floating point error https://docs.microsoft.com/enus/office/troubleshoot/excel/floatingpointarithmeticinaccurateresult which is not specifically Excel issue.

1 vote2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
That's not a bug, that's interpretation. If you use QUARTILE.EXC() https://support.office.com/enus/article/quartileexcfunction5a355b7a840b4a01b0f1f538c2864cad it returns result exactly the same as your manual calculations. And it's differ from what QUARTILE.INC() and QUARTILE() return.

2 votes0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Sergei Baklan supported this idea ·

1 vote2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Robert, was not able to reproduce. I'm on 1912.1235.20012, English SKU

1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Was not able to repeat  version 1912, English SKU

1 vote1 comment · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Afraid that never will be corrected  end of 2010 support in next year, and in later versions the spelling is correct.

1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Fred, please check the discussion here https://excel.uservoice.com/forums/304921excelforwindowsdesktopapplication/suggestions/37609729exceliswrongincalculatingx2

5 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Sergei Baklan commented
That's not Excel, that's Windows. Go to your regional setting (Win+R and type 'control international'), Additional settings, Date, and here you may change the range for twodigits year interpretation. By default it is between 1930 and 2029.

22 votes10 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan supported this idea ·

1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Blank cell is considered as zero if you compare the numbers. Dates in Excel are actually sequential integers where 1 is equal to 01 January 1900. Thus any blank cell is less than any date.

1 voteSergei Baklan commented
So far that's only for Office Insiders Fast, are you on this channel?

1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Kenneth, you may add based on data model both PivotTable and PivotChart from Excel sheet ribbon. Just in Insert>PivotTable popup window select "Use this workbook's Data Model"

1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
That's like =INDEX(A:A,COUNTA(A:A))A1

1 vote3 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Insider Fast?

2 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
That is XMATCH

6 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Sergei Baklan commented
Yes, negation means (1)* and subtraction means minus. If use two different characters for negation and subtraction everything will be logical.
Sergei Baklan commentedActually second link shall be http://mathforum.org/library/drmath/view/69058.html
Sergei Baklan supported this idea ·Sergei Baklan commentedHi Martin,
That's a great question why people who designed Excel more than 30 years ago decided what negation is to be performed before exponentiation. But that's what they did, the order of Excel operations is described here https://support.office.com/engb/article/theorderinwhichexcelperformsoperationsinformulas28eaf0d770584effa8ea0a835fafadb8. By the way, exactly the same logic is used for Google Sheets, it also returns +36 if type =6^2.
That is almost 20years old but quite interesting discussions about the subject on Math Forum https://support.office.com/engb/article/theorderinwhichexcelperformsoperationsinformulas28eaf0d770584effa8ea0a835fafadb8.
I'm very suspicious what that will be ever changed. Same with year 1900  someone who designed Excel decided what that is the leap year, which is not. That issue is also known for about 30 years, but it never will be corrected due to compatibility. There are only support articles which explain what we have what we have and have to live with that.

2 votesSergei Baklan commented
Hi Gordon  that's a trigger, click "Show all notes" again to hide them
It allows if you use From File>From Sharepoint Folder connector and use your OneDrive URL