This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
I'm trying to make an in-company guide to Excel (we're a small non-profit and sorely need some sort of baseline …
excel excel-formula sumifsI'm using VBA, and I need to insert an array formula (the one that if I'm writing it manually, I'll …
vba excel excel-formula array-formulasRecently I switched from MS Office to OpenOffice.org 3.4.1. Here are my questions: I was not able to save .ods …
excel ms-office excel-formula openoffice.org openoffice-calcConsider the following Excel sheet: A B C 1 ASX:ANZ ANZ:ASX http://www.site.com/page?id=ANZ:ASX 2 …
excel excel-2007 excel-formulaConsider the following two formulas: =IF(SEARCH("*", A1), "true", "false") =IF(SEARCH(CHAR(42), A1), "true", "false") I am using this …
excel excel-formulaI have a gant with start date, end date, and % complete columns. By manually entering a number in the % column …
excel excel-formula datediffI am calculating all the hours/minutes/seconds of all calls made on our PABX system. The cell has to …
excel excel-formula excel-2016How do you get the sum of all values of A if it has "foo" in column B? In the …
excel excel-formulaI have boolean values in a column: A 1 TRUE 2 FALSE 3 TRUE 4 TRUE I realize that in Excel =TRUE+TRUE returns 2 …
excel excel-formulaI've recently discovered that you can use SUBTOTAL for various functions which allow you to sum up or find totals …
excel excel-formula excel-2010