Hi,
Is there any way how I can get with function IF a result in some range of data?
For example:
I have two columns with data
A1 - 100 B1 - 104
A2 - 12 B2 - 13
What I want is IF B1 is +/-3 than it returns "Same", IF smaller than +/-3 "Down", else "Up".
Last edited by Yahoho; 06-15-2012 at 08:11 AM.
Hi Yahoho, welcome to the forum.
You could try either:
=IF(ABS(A1-B1)=3,"Same",IF(ABS(A1-B1)<3,"Down","Up"))
or
=LOOKUP(ABS(A1-B1),{0,3,4},{"Down","Same","Up"})
Hope that helps!
Hi,
It looks like it isin't what I need.
I added an example with data and my variation, that returns result if it perfectly match. But with posted options I don't get right result.
Show us what *SHOULD* be the result for all of those examples, and explain why for the first several rows.
Hope this time I will make my self clear.
See attached example and explanation.
Hello
can you try again the above explanation...
What I want is IF B1 is +/-3 than it returns "Same", IF smaller than +/-3 "Down", else "Up".
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Try
=IF(ABS(A2-B2)<=3,"Same",IF(A2-B2>3,"Up","Down"))
maybe like this..
=IF(AND(A2<B2,ABS(A2-B2)>3),"Down",IF(AND(A2>B2,ABS(A2-B2)>3),"up","Same"))
Both solutions works perfectly. Thank you very much.
use the shorter one...
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks