If Statement/Excel 2007

[knaimi]

I have created three columns (A, B, & C) in Excel 2007 that contain number values. I’m trying to create one “If Statement” in column D that does the following:</SPAN>

1. If the value of the number in column C is less than both or any of the other two numbers then type 1
2. If the value of the number in column C equals the value of both numbers Or if it equals one but greater than the other then type 0
3. If the value of the number in column C is greater than the value of both numbers then type -1

</SPAN>
Example: </SPAN>

A</SPAN>	B</SPAN>	C</SPAN>	D (If Statement)</SPAN>
3</SPAN>	4</SPAN>	3</SPAN>	1</SPAN>
4</SPAN>	2</SPAN>	4</SPAN>	0</SPAN>
6</SPAN>	7</SPAN>	8</SPAN>	-1</SPAN>

<TBODY>
</TBODY>

Thank you,</SPAN>

 

[etaf]

I just cannot get the code into the forum

i will send in a PM

Excel Workbook
	G
6	-1
Sheet1

 

[jjones312]

=IF(OR(AND($C1<$A1,$C1<$B1),$C1<$A1,$C1<$B1),1,IF(OR(AND($C1=$A1,$C1=$B1),AND($C1=$A1,$C1>$B1),AND($C1=$B1,$C1>$A1)),0,IF(OR(AND($C1>$A1,$C1>$B1)),-1,"Didn't many any criteria")))

adjusted formula

 

[jjones312]

I copied the formula and paste it into D6. When I hit enter, it gave me an error message.
I have Excel 2007

thanks,

what was the error?

 

[jjones312]

here are my results..

A B C D

3	4	3	1
4	2	4	0
6	7	8	-1
6	7	2	1
10	8	3	1
10	5	6	1
10	5	2	1
5	7	8	-1
5	7	6	1
5	5	5	0
5	3	5	0
5	6	5	1

<tbody>
</tbody>

 

[etaf]

i have sent a PM

 

[knaimi]

Thanks, this one worked

 

[etaf]

=IF(OR(AND(C6 < A6, C6 <b6 ),="" c6<a6,="" c6<b6),1,if(or(and(c6="A6," c6="B6" and(c6="A6,">B6), AND(C6>A6, C6=B6)),0,IF(AND(C6 > A6, C6 > B6 ),-1,"does not meet conditions")))

give up - anyway you have a PM </b6>

 

[knaimi]

There was no error in yours. It worked.

Thank you for your help