if bigger than

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Hegefors - 13 Feb 2007 15:46 GMT

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!

Reply to this Message

JE McGimpsey - 13 Feb 2007 15:54 GMT

one way:

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

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

Reply to this Message

Sandy Mann - 13 Feb 2007 16:33 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> 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
[quoted text clipped - 4 lines]
> 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!

Reply to this Message