Hi, total beginner here...
This formula is supposed to look at whether column Bx contains the string '142', and if it does, to print the value of cell Ex in cell Gx. Except it doesn't. I thought the syntax was correct, is it not?
in column G:-
IF(B1:B871,"*142*", E1:E871)
I've attached a short example jpeg to illustrate the problem; G6 should read "0.9585"
Thanks anyone who can help!
Bookmarks