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 […]

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

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