conditionals statements

[out0015]

A B C D
E F




3795 59 TH ST ELEMENTARY 28 5548 22 >
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60


Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 22>21. 6781 in column D is less than 6781
in column A 49+6= 55>50.

 

[Luke M]

I believe you posted this earlier in the forum! You need to explain yourself
more, simply saying "compute" is not a legitimate term for describing what
you want. You also tend to create sevearl run-ons in your logic, making it
unclear. You state that 6781 is less than 6781, which makes no sense. Also,
we have no idea what the 49+6=55>50 has to do with anything. Is the text
embedded in the cells with numbers? If not, is it even important?

Why does the last line missing half the data??

Instead of repeatedly posting the same thing, try to give more detail.

 

[Luke M]

To help my fellow experts find your other posts and suggestions that have
been given already:

http://www.microsoft.com/office/com...&p=1&tid=3ea5b3a2-41b6-49e6-9988-a3e00ebb718e

http://www.microsoft.com/office/com...&p=1&tid=1ab1920e-3bd4-4abb-9000-cdddc55815dd

http://www.microsoft.com/office/com...&p=1&tid=14cebe81-a20f-4427-8b5b-5eac815d646b

 

[out0015]

I tried to post it clearly but the screen could only fit so much.
The last column F is the < > = column that i want to input automatically
when i manually input column E. the 6781 in column D is less than 6781 in
column A in terms of column C. I am trying to compare column C to column E,
thats it!
by looking at column E, look at the same number at column A then column A is
associated with column C, so we are comparing column E to column C. 6781 in
column E = 53 compare that to column A (which means look at the value of
column A in column C. column A has to inputs of 6781 so add those two you get
49+6= 55, which gets 53<55.

 

[Luke M]

Thanks for clearing it up. Assuming your data starts in row 1:

=IF(E1=SUMIF(A:A,D1,C:C),"=",IF(E1>SUMIF(A:A,D1,C:C),">","<"))

 

[out0015]

It looks fine but I missed 1 column , a column between D and E that is for
the name of the schools (same name as column B)
pLease advise.

thanks

 

[out0015]

ALSO IF YOU COULD PLEASE SHOW THE AMOUNT OF OVERAGE AND UNDERAGE IE > 2, OR
<3.
ALSO IF YOU COULD ADD A COLUMN OF NON PARTICIPATING SCHOOL MEANING COLUMN E
DOESNT EXIST IN COLUMN A.

I APPRECIATE YOUR HELP

 

[out0015]

ALSO IF YOU COULD PLEASE SHOW THE AMOUNT OF OVERAGE AND UNDERAGE IE > 2, OR
<3.
ALSO IF YOU COULD ADD A"NO SCHOOL" IN COLUMN F FOR NON PARTICIPATING SCHOOL MEANING COLUMN D
DOESNT EXIST IN COLUMN A.

I APPRECIATE YOUR HELP

 

[Luke M]

It sounds like you need the references shifted slightly, to account for added
column?

=IF(ISERROR(MATCH(E1,A:A,0)),"Does not
exist",IF(F1=SUMIF(A:A,D1,C:C),"=",IF(F1>SUMIF(A:A,D1,C:C),">"&F1-SUMIF(A:A,D1,C:C),"<"&F1-SUMIF(A:A,D1,C:C))))

Note that if the range references are still slightly off, you can adjust
them fairly easily.

 

[out0015]

everything looks good, except for one thing.If column D has two entries, your
current formula doesn't add them together. Could you please make an
additional formula that will add two or more entries in column D? Adding them
up and comparing the result to column C? ie 3795= 28, 3795=6 so column D will
have
a total of 34. which results in 3428.

 

[out0015]

everything looks good, except for one thing.If column D has two entries, your
current formula doesn't add them together. Could you please make an
additional formula that will add two or more entries in column D? Adding them
up and comparing the result to column C? ie 3795= 28, 3795=6 so column D will
have
a total of 34. which results in 34>28, not = like before.