Some Cells Not Working

[KEVIN GUNN]

I have a spreadsheet I'm trying to use to sort through data on. I have
the data arranged in a chart and I'm using the AND command to sort
though the data. The problem is I'm using the same formula for all the
rows but only some of them work. Here’s the way the data is laid out:


A B C D
1 1
2 1/4
3 1.5
4
5
6
7
8
9
10 1 1/4 1.5 =AND(A10=$A$1,B10=$A$2,C10=$A$3)
11 1 1/4 2 ABOVE FORMULA COPIED TO ALL ROWS
12 1 3/8 2.5
13 1 3/8 3
14 1 1/2 3.5
15 2 1/4 1.5
16 2 1/4 2
17 2 3/8 2.5
18 2 3/8 3
19 2 1/2 3.5
20 3 1/4 1.5
21 3 1/4 2
22 3 3/8 2.5
23 3 3/8 3
24 3 1/2 3.5
25 4 1/4 1.5
26 4 1/4 2
27 4 3/8 2.5
28 4 1/2 3
29 4 1/2 3.5

This will give a solution of TRUE like its supposed to, but if I change
A1 to 2, 3, or 4 it won’t doesn’t work. Anybody know why?

 

[MrShorty]

Seems to work to me. What do you mean by, "it doesn't work?" What ar
you expecting it to give you

 

[KEVIN GUNN]

By changing the variables in rows 1, 2, and 3 it should just chang
which row is TRUE, but if I have anything but 1 in the first variabl
it just gives FALSE for all. I think it may be a problem with excel an
not so much my formulas. I could be wrong though. I have more happenin
on the same worksheet, if you would like I'll e-mail it to you
(e-mail address removed). send a message here and I'll send yo
the document

 

[KEVIN GUNN]

here is the file...


+-------------------------------------------------------------------+
|Filename: eq calc 3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3521 |
+-------------------------------------------------------------------+