QUESTION : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

# Tag: conditional-statements

## I can’t tell why my IF statement is producing false result

QUESTION : =IF(0<VLOOKUP($A9&$E9,’All Orders Avg’!$Q:$S,3,FALSE)<1,1,VLOOKUP($A9&$E9,’All Orders Avg’!$Q:$S,3,FALSE)) The IF Statement is supposed to find values between 0 & 1 and […]

## Using AVERAGEIF() over a range of years

QUESTION : I have a dataset that includes year, country, and population data. A small condensed sample is below. I […]

## Excel over 100% then = 100%

QUESTION : I am calculating percentage and currently I have cells with the formula =IF($H4=”3PL”,L4/Data!B$24,L4/Data!B$21) I need to add a […]

## Vector Compare to Scalar

QUESTION : Is it possible to compare a vector of values to a single scalar value in Excel? Example: =IF(A1:Z1 […]

## Multiple IF statements and concatenation in Excel

QUESTION : So far I’ve managed to concatenate cells I1 and J1 with the words “From” and “To” and put […]

## Disable certain drop down list selections based on another cell

QUESTION : Let’s say that in column A, users enter in different numbers. In column B, there are options of […]

## Excel: conditional COUNTIF?

QUESTION : How can I evolve =COUNTIF(A:A;”foobar”) so that if the cell in column A is empty, it looks (for […]

## Delete every row that doesn’t contain a blank

QUESTION : I need to delete every row in Excel that does not contain a “blank” value in one of […]

## Is there a better way to accomplish this? Excel copy-pasting using conditional statement based on formatting conditions of the cells above and below

QUESTION : How can I achieve the after where the dates are copied next to the appropriate expenses without having […]