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 need to make a formula that gives you the truth table for a variable number of columns. Example
excel excel-formula truthtableAlright, I have two excel functions that work. I want to combine them into one. Here are the two that …
excel concatenation excel-formula countif>> Question summary I want to implement a resettable, over-ridable, default cell value in Excel. By this, I mean …
vba excel excel-formula worksheet-functionI like to have an Excel Function for: Previous cell + Current Cell = Current cell to do this function for the …
excel excel-formula sum worksheet-function excel-indirectI would like to use VLOOKUP() using a table input consisting of columns that are not next to each other. …
excel excel-formula vlookupI have a column "HEX" and three columns "R", "G", and "B". How can I convert a HEX to RGB, …
excel excel-formula hex excel-2010 baseI have a formula with the following syntax: =SheetName!E10 and need some way to drag the formula and change …
excel excel-formula worksheet-function excel-indirectI have some data in a row, say A1 to Z1, and I would like to link to this data …
excel excel-formula transpose formulas array-formulasCan't believe I don't know this, but is there a way to avoid repeating a formula in an if statement …
excel if-statement excel-formulaI'm looking for a way to create a running total (total of the current row and above) using Excel table …
excel excel-2007 excel-formula