Numbers Formula

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

Let's say the range you are looking in is column A. Then you could do something like this:

The formula in B2:

=IF(COUNTIFS(A,">1",A,"<15")>0,"yes","no")

Substitute ; for , in the formula if your regions uses , as a decimal separator.

SG