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

DevenSlaves

New Member
Joined
Oct 4, 2017
Messages
2
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.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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"))
 
Last edited by a moderator:
Upvote 0
=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
 
Upvote 0
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
ABCDEFGHI
112345678
24upupstablestablestablestabledowndown
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"?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top