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
[TABLE="width: 348"]
<tbody>[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[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