1. H

    'IF' formula to test range of cells

    Dead simple, but oh so hard! All I want to do is test if A1:E1 contain anything, and if so, put an 'x' in F1. I have tried {=IF((A1:E1)>1,"x")} (array formula) but this only works on A1 and ignores the rest of the range. I have also tried various combinations of Countif etc with no joy...
  2. J

    Variance with IF

    Hi! I have a problem with calculating the variance of 2 columns. Column B has a list of values already in it and column A is empty. What I want to do is as a value has been entered in column A, I want to calculate the percent difference between columns A and B. BUT only the % difference...

Some videos you may like

This Week's Hot Topics