QUESTION : I have a huge spreadsheet of PC’s and the software that is installed on them. Unfortunately the report […]

# Tag: microsoft-excel

## Strange results with BITXOR in Excel

QUESTION : I get the following results with Excel 2016 MSO (16.0.6701.1011) 64-bit: =BITXOR(10,1111) produces: 1117 I expected 1101. However […]

## Record multiple calculation results at each change of single input cell

QUESTION : I have a spreadsheet that calculates reduced generation and emissions per fuel source for the state of Wisconsin […]

## Excel combining IF formulas

QUESTION : I have 14 different IF formulas I am trying to combine. They are all different calculations (see below). […]

## Excel – IF formula for multiple cells

QUESTION : I have 5 cells with either 1, 0 and -1 values. I want to build a formula that […]

## Proper syntax for complex equation in excel

QUESTION : I’m trying to translate this equation into excel. My closest attempt was =1200*(1.12)^4 -1/ 0.12*(1.12)^4/(1.12)^4, but instead I […]

## Column letter(s) based on value

QUESTION : I download a sheet every two weeks where I use a formula to calculate specific expenses. The names […]

## In excel how could I generate a row of data from another sheet?

QUESTION : In excel I have a sheet named “sales”, and another one named “factor”. In factor I have some […]

## vlookup with blank look up value

QUESTION : I have a Vlookup formula that I want to return 0 if the returned value is empty. example: […]

## Copy names from one sheet into another sheet based off date selected

QUESTION : I’ve created a workbook to track ticket sales for an event we have coming up. The guests have […]