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!

one way:

=IF(A110, INT(A1/10),"")

In article ,
Arne Hegefors wrote:

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!

You don't say what you want if the first matrix number is less then 10 but
assuming that you want zero try:

=FLOOR(A1,10)/10

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Arne Hegefors" wrote in message
...
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!