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.
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.