Numbers Formula
Please could anyone help with numbers formula, I am trying to create a formula which will look at a range of cells and if any value in selected cells is equal to or greater than 1 but less than 15 enter yes. Thanks
Question marked as
Top-ranking reply
sunglasses ron wrote:
if I had values in columns A,B,C,D and i wanted the formula to check each cell across a row and return a yes or no if any one of the four cells complies with greater than or equal to 1 and less than 15.
Hi Ron,
In that case you could do something like this:
In F2, filled down:
=IF(COUNTIFS(A2:E2,">1",A2:E2,"<15")>0,"yes","no")
If you want to include 1 and 15 in the "yeses" then you would change the formula slightly, to this:
=IF(COUNTIFS(A2:E2,">=1",A2:E2,"<=15")>0,"yes","no")
SG