Top "Excel-formula" questions

This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.

Excel formula to reference 'CELL TO THE LEFT'

I'm trying to do conditional formatting so that the cell color will change if the value is different from the …

excel excel-2007 excel-formula
Count if two criteria match - EXCEL formula

I have this table and I would like to create a formula which would count values based on true conditions …

excel excel-formula
IF - ELSE IF - ELSE Structure in Excel

Requirement : If the string in cell A1 contains "abc" as part of the string Then assign value "Green" Else if …

excel excel-formula
Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …

excel excel-2007 excel-formula excel-2010 vba
PivotTable to show values, not sum of values

I'm wanting to display a pivot table and for it to show me the actual values, one on each row, …

excel if-statement excel-formula excel-2007 pivot-table
Excel - find cell with same value in another worksheet and enter the value to the left of it

I have a report that is generated in Excel which contains an employee's number, but not his/her name. Not …

excel excel-formula spreadsheet vlookup
In Excel, how do I extract last four letters of a ten letter string?

For example, if I have ABS YUR YUAO HFH IWO OQNX YQO PQM QUCC How do I extract the last …

excel extract excel-formula
What's the quickest way to multiply multiple cells by another number?

If I have a block of cells such as A1:D5, what's the quickest way of multiplying each cell by …

vba excel excel-formula
Substring in excel

I have a set of data that shown below on excel. R/V(208,0,32) YR/V(255,156,0) Y/V(255,217,0) R/S(184,28,16) YR/…

excel string excel-formula substring
Format numbers in thousands (K) in Excel

In MS Excel, I would like to format a number in order to show only thousands and with 'K' in …

excel excel-formula