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 have multiple spreadsheets in a workbook and I would like the following in basic English talk: IF worksheet1(cell)…
excel excel-formula vlookupI have created a spreadsheet in Excel and am attempting to use Conditional Formatting to highlight a cell or row …
excel excel-formula conditional-formattingI'd like to write a formula such that if cell A1 displays #VALUE!, say TRUE in cell B1. Here's my …
excel excel-formulaI want to search a cell for a list of words. I thought this would work as an array formula: {=…
excel search excel-formula findSuppose I have: a value of 5 in B1 I want to pass the number (5) in B1 as a row variable, …
excel excel-formulaI'm wondering if there is an easy way to do what I'm looking for. Basically, I have a balance sheet …
excel excel-formulaI am trying to do simple thing: I just need to set some cells to values that are on the …
excel excel-formulathis is simple demo of what i want to do. I want to set a formula to a range of …
vba excel excel-formulaI've got a massive Excel 2003 spreadsheet I'm working on. There are a lot of very large formulas with a lot …
excel excel-formula reference cell copy-pasteI have a week number and a year, and would like to calculate the date of the Monday for that …
excel date excel-formula