Please help

[PS]

Hi,

Once again I need your help guys,

Ive got to colums of data :

3 4
5 7
5 8
6 9
etc. etc.
I want to set up a formula that determites if A and B are inside some
different ranges, and
thereby set C to a value. I tried with IF but i got 12 sets of ranges...
Is it possible to do in a matrix ?

Best regards,

Sauer

 

[J.E. McGimpsey]

Your question has at least a couple of strikes against it:

1) Your title says nothing about what your real subject is
2) Your question is not very specific.'


While I 'm sure you know exactly what "inside some different ranges"
means to you (or even A and B, though I could make a guess), it's
not at all clear to me (ranges of numbers? ranges of cells?), nor
what your desired C output is (single cell, range?).


See http://cpearson.com/excel/newposte.htm for tips on using these
groups effectively.