A formula is a mathematical equation or expression that performs various operations on variables to produce an outcome.
I am using a combination of if, vlookup, match, iserror functions, and unfortunately I've not been able to find the …
excel vlookup formulas excel-matchI have data in one google docs. Call it docA. I would like to reference this data in docB. Something …
google-sheets formulasI'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But …
google-sheets formulas google-sheets-query google-query-languageHow does one cell obtain the formula of another cell as text without using VBA? I can see this question …
excel formulasIn the new Google sheets there's a way of formatting a number as a duration. Format -> Number -&…
time google-sheets duration formulasI'm looking for some expertise with formulas. I've got a raw data source and need to be able to summarise …
google-sheets countif formulasI know this looks simple. In a Google spreadsheet, I have a column where I enter time in one timezone (…
google-apps-script google-sheets timezone dst formulasLet's say I have 6 different cells (that are not all in a line). I want to check if the values …
google-sheets worksheet-function formulasI need to achieve the following when opening an HTML in Excel (Response.contentType="application/vnd.ms-excel") : force Excel to …
html excel formatting numbers formulasHow can I change the #N/A to the blank cell if nothing in that cell? Eg. =VLOOKUP(B19:B36;$…
openoffice-calc formulas