Claus Busch wrote:
Am Fri, 06 Sep 2019 10:31:58 +0100 schrieb Terry Pinnell:
I want to scan down a column of decimals and if any group has four numbers which are
all less than or equal to 0.6, then I want to copy a number from column A alongside
the first of those four cells. Hopefully my screenshot clarifies this.
Thanks Claus, but neither seem to work.
No results are placed in col L for any valid set of four successive cells, such as
which should enter 2 in L2
Or the example I showed in my screenshot.
I think I could do it myself if you could tell me:
" how to construct a sort of 'combined IF'. Expressed at
its simplest, how would I write IF(This AND That are true, then do X, else do Y),
where This and That are values in separate cells?"
Something like this:
IF(K1<0.6 AND K2<0.6 AND K3<0.6 AND K4<0.6, A1, "")
I would then place the formula in L1, then copy that down the whole column. That
should do it, yes?
Terry, East Grinstead, UK