if bigger than

A

Arne Hegefors

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!
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top