Hi! I have a matrix. I want to create another matrix on the basis of the
first one. I want to check a number in a cell in the first matrix is bigger
than 10. If so I want the number 1 in a cell in the other matrix. if the
number in the first matrix is bigger than 20 i want the number two and so on.
the problem is that is you use =if(...) it wont work for 20 becuase 20 is
bigger than 10. how can i do this? any help appreciated!