96 Why does =-x^2+x for x=3 in Excel result in 12 instead of -6? 2018-12-18T13:52:31.647

89 In Excel, how do I check if a cell is in a list of values (a range of cells) 2013-05-29T20:43:50.250

77 Format a number with optional decimal places in Excel 2008-08-22T04:31:59.497

77 How to create a formula for every row in a column in Google SpreadSheet? 2011-03-21T21:03:19.213

75 Type math formulas in Microsoft Word the LaTeX way? 2011-09-28T02:13:27.643

61 What is the Excel hotkey to re-calculate all formula in sheet? 2012-07-13T07:27:12.693

61 Excel - can I set a cell to equal a certain value, no matter what is typed in it? 2015-09-29T15:03:40.760

59 Is it possible to sum an entire column without setting explicit cell boundaries in Excel? 2010-05-17T22:25:12.057

58 Formula for updated currency exchange rates in Excel or other spreadsheets? 2011-05-20T12:07:44.203

45 How to compare two columns and find differences in Excel? 2011-05-27T07:10:09.147

45 Is there a concise Excel formula to calculate (A1*A6)+(B1*B6)+(C1*C6)...? 2018-08-19T14:24:52.350

44 What does "A1:A4^{1,2,3}" mean in an Excel formula? 2015-03-04T19:08:16.600

38 Create a pie chart from distinct values in one column by grouping data in Excel 2011-08-29T14:22:19.153

35 How to simulate a full outer join in Excel? 2016-01-07T16:52:52.173

33 How do I get the day name into a cell in Excel? 2009-09-15T23:04:12.367

32 How to count number of distinct values in a range? 2010-09-17T14:13:03.627

31 How to get the current column name in Excel? 2011-07-28T14:32:58.437

31 In Excel how can I sum all the numbers above the current cell? 2013-10-18T15:04:37.573

31 Limit Excel CPU Usage 2016-01-12T20:26:48.310

30 AND function gives TRUE result for empty, BLANK cell - why? 2016-08-31T11:35:42.373

28 Excel function that evaluates a string as if it were a formula? 2011-03-04T21:41:05.697

28 How do I hide the #DIV/0! error while a referenced cell is blank? 2015-10-01T00:53:18.900

27 How do I put logical operators in an Excel =IF Formula? 2011-01-07T12:25:58.907

27 Is there an Excel function to create a hash value? 2013-02-13T14:35:30.257

25 Excel formula to convert boolean values into {0, 1} 2012-08-30T18:26:39.023

23 In Excel, can I provide a "default value" in case my formula returns #NA? 2012-03-08T15:07:08.157

22 Can you do Regular Expressions in Excel without VBScript? 2010-08-26T14:39:01.177

20 How do I get the =LEFT function in excel, to also take the number zero as the first number? 2019-08-06T03:42:11.870

19 How to get time difference as minutes in Excel? 2009-12-29T15:15:41.947

19 How to search for newline or linebreak characters in Excel? 2011-12-21T02:02:23.697

17 I need to find the last Space in a XLS Cell 2013-11-26T12:15:07.497

16 Reference Excel sheet with apostrophe in name 2016-12-15T20:25:27.627

15 Shortcut to accept suggested formula in Excel 2011-04-27T14:44:07.457

15 Is there a function in Excel to find the maximum absolute value of a range? 2011-10-14T00:38:16.547

14 Excel: Replace occurences of one character with another in a String? 2009-10-18T00:49:32.180

14 Microsoft-excel newlines and tab 2012-03-19T04:26:29.307

13 Best way to remove leading zeros from a non-numeric value in Excel 2009-09-17T18:53:17.067

13 Change year in many date fields in excel? 2010-09-22T15:16:07.400

13 Check if Excel cell text is numeric using formula only 2013-04-30T01:05:15.623

13 Is there an Excel formula to identify special characters in a cell? 2013-10-16T13:34:39.460

13 How do I append a character to the end of every line in an Excel cell? 2019-02-26T22:02:56.433

12 Is it possible to get the sheetname? 2010-12-07T18:57:51.950

12 Excel, how to find column number of min value? 2012-07-22T16:35:30.517

12 Dynamically reference a Named Table Column (via cell content) in Excel 2012-08-13T14:46:33.303

12 How do I copy the results of a calculation without copying the formula behind it? Open Office Calc 2013-02-27T05:37:51.053

12 How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database? 2013-10-18T21:03:56.937

12 Excel function determine if a cell is visible 2015-03-03T21:08:32.380

11 What Excel formula can I use to calculate the 2nd Monday of a given month? 2011-11-20T22:57:10.207

11 How to make Excel 2010 auto-fill new row with formulas? 2013-02-20T08:30:32.813

11 Excel-Overcoming #VALUE error with FIND function 2013-11-11T12:32:03.537

11 Fill a large range with a formula in Excel, without mouse-dragging to extend 2015-07-31T09:05:20.610

11 One-digit and two-digit separation 2017-01-30T09:07:27.470

10 Using excel, how can I count the number of cells in a column containing the text "true" or "false"? 2010-05-09T22:48:57.140

10 What is the difference between function and formula in Excel? 2010-07-21T07:05:14.563

10 How to separate number by its decimal point in Excel/Calc? 2011-05-09T03:43:43.997

10 AutoFill Large Number of Cells in Excel? 2011-12-03T17:12:07.897

10 What is a formula to remove the whitespace from an Excel cell when trim doesn't work? 2011-12-22T02:51:22.620

10 How to combine values from multiple rows into a single row in Excel? 2012-02-28T22:05:49.887

10 Using find() in Excel to remove text from string 2013-08-26T20:17:16.653

10 Custom user function without using VBA 2014-04-17T20:01:31.827

10 How does the NOW() function get evaluated cross time zones in Excel Online? 2014-06-05T13:20:09.520

10 When I copy table data into excel, it ONLY pastes it into column A! How to fix this? 2015-01-14T21:43:39.930

10 What would be the the mathematical equivalent of this excel formula? =PMT() 2015-01-30T02:30:15.910

10 Convert the multi-step sum of booleans into a single formula 2018-07-03T08:57:25.193

9 Sum contents in column from starting cell on down without setting an explicit last cell index 2011-04-28T18:59:18.347

9 How to keep random numbers from changing in Excel? 2014-04-24T22:28:59.417

9 Convert Text Value to Time Value in excel 2014-10-30T18:07:30.163

9 Switch Calc (or Excel) formulas to English language 2015-08-11T23:50:25.257

9 Looking for solution to shorten an IF formula 2017-11-24T12:12:47.083

9 Combining first two letters from first name and first two letters from last name 2018-12-10T12:25:40.953

9 How do I keep a running total of data in a column in Excel? 2019-06-28T12:32:53.077

8 Shortest Method To Reference A Single Row/Column of a Named Range in Excel? 2010-06-24T19:54:07.520

8 Subtracting cells only if they have a value in Excel 2011-04-16T20:11:17.947

8 How do I insert formula in between sentences? 2011-05-16T12:03:42.110

8 How do I find out what's linked to my Excel Worksheet? 2012-06-18T14:23:04.050

8 Hide "inconsistent formula" error in a selection in Excel 2013-04-10T12:37:57.410

8 Tab (\t) is not recognized as columns delimiter when pasting into Excel 2013 2013-05-29T16:59:31.283

8 How do you write an Excel formula that will paste a specific value in a different cell? 2013-05-31T15:52:45.303

8 How do I make Excel recognise TRUE or FALSE text as boolean values? 2013-09-27T10:11:21.607

8 How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)? 2013-11-21T17:35:43.297

8 How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function? 2014-04-23T16:16:56.317

8 Searching for a value in Excel, returning yes or no 2014-05-21T20:08:24.160

8 Calculate number of Sundays in the month 2014-06-19T01:45:43.283

8 How to compare two Excel spreadsheets? 2018-01-25T11:54:01.683

7 Is there a way to give an Excel table a name that is worksheet-scoped instead of workbook-scoped? 2010-08-07T17:56:57.857

7 How do I get a reference to the last occurrence of a value in an array in Excel? 2008-12-11T16:17:24.567

7 Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm 2011-08-09T16:27:22.000

7 Get column number of an address in Excel 2012-01-09T14:46:28.093

7 Merging columns in Excel with ";" separator 2012-02-08T08:33:39.567

7 How do I calculate number of hours > 24 in Excel? 2012-05-25T15:15:25.390

7 Excel - define a formula in one cell to be used in other cells with different inputs like a function 2012-05-30T10:17:09.747

7 How do I create a data validation list WITHOUT using cells? 2012-07-11T23:46:08.570

7 How to add/subtract months from given date in Excel 2013-05-23T19:39:36.107

7 Exclude outliers from average calculation 2013-06-07T18:00:32.017

7 Formula for finding 'near perfect' matches 2013-11-01T18:59:54.803

7 Excel Formula To Get First Non-Zero Value in Row and Return Column Header 2013-11-08T16:43:38.697

7 Excel TEXT function does not work properly 2014-03-17T12:46:38.943

7 Average numbers if another column contains a certain substring text in Excel 2015-07-23T20:13:46.280

7 How do I reference an Excel sheet name in an Excel formula? 2015-07-29T11:42:34.440