Hello! I have a small problem. I want to search a value in an array and
return the value true or false. I tryed with "if", "and", "not", but a
strange thing happends: when I press the function button to see if my formula
is wrong, it seems that the formula is corect, but when i insert the formula,
it says: #N/A, #VALUE!. the formula is
IF(A3<Array1,IF(A3<Array2,IF(A3<Array3,"VALUE1, VALUE2)),VALUE3). A3 is the
refference; Array1,2,3 are the arrays where i want to find the value; and
Value1,2,3 are the results. Can anyone please help me!