Need Greater Than, Less Than and Equals To in Single Formula

[DevenSlaves]

Hey Guys,

I am new to this forum and need help with excel formula to calculate Up, Down & Stable figures.

A B
4 4
3 4
7 6

What I need is,
If figure in ColB>ColA = Result should be "Down"
If figure in ColB<ColA = Result should be "Up"
If figure in ColB=ColA = Result should be "Stable"

I have this one, =IF(B1>C1,"Down","Up") , however it doesn't work for equals to results. Can't insert multiple argument in one formula.

Please provide me a solution.

 

[joeu2004]

If figure in ColB>ColA = Result should be "Down"
If figure in ColB<ColA = Result should be "Up"
If figure in ColB=ColA = Result should be "Stable"

=IF(B1>A1, "Down", IF(B1< A1, "Up", "Stable"))

 

[DevenSlaves]

=IF(B1>A1, "Down", IF(B1<A1, "Up", "Stable"))

Hey Joe, sorry the requirement was incomplete. Here is it.
If figure in ColB>ColA by minimum 2 figures then result should be "Down"
If figure in ColB<ColA even by 1 figure then result should be "Up"
If figure in ColB=>ColA by just 1 figure then result should be "Stable"

Let me know if anyone can provide me a solution for this.

Thanks!
Deven

 

[joeu2004]

If figure in ColB>ColA by minimum 2 figures then result should be "Down"
If figure in ColB<ColA even by 1 figure then result should be "Up"
If figure in ColB=>ColA by just 1 figure then result should be "Stable"

Please provide numerical examples of values in col B and col A that do and do not meet each criterion separately.

I do it this way (sorry about the garbage below; bug in this forum's tools):

Book1
	A	B	C	D	E	F	G	H	I
1		1	2	3	4	5	6	7	8
2	4	up	up	stable	stable	stable	stable	down	down
Sheet1

What does "2 figures" and "1 figure" mean?

Perhaps the following in B2, copied into C2:I2:

=IF(B$1 < $A2-1, "up", IF(B$1 > $A2+2, "down", "stable"))

I changed of the order the "up" and "down" tests because with my interpretation (which might be wrong), it makes the "stable" range clearer, to wit:

"stable" A2-1<=B1 and B1<=A2+2

which we can see is a valid continuous range.

Is that your intent, subject to your definition of "figures"?