In my problem, I have two variables I am comparing--A and B. I would like to create a function that compares A and B for 1 of 3 possible combinations. If A = B, I want a "" value returned; if A>B, I want "Upgrade" returned; and lastly, if A<B, I want "Downgrade" returned. I know this is a fairly simple nested logical function, but I've been struggling with it for about an hour and failed to get what I am looking for.....please help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Logical function help
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,301
- Office Version
- 365
- Platform
- Windows
Your last condition got chopped off, but one way is to use a nested if statement structured something like this:
Not that since if A is not equal to B, and if it is not greater than B, then we really don't have to check to see if it is less than B, as that is the only thing left it can be (other than an error, I suppose).
That is what we did not check the last condition.
Note, you didn't mention if you wanted a regular Excel formula or VBA. If VBA, please let us know.
Code:
=IF(A=B,"",IF(A>B,"Upgrade","whatever last condition was"))That is what we did not check the last condition.
Note, you didn't mention if you wanted a regular Excel formula or VBA. If VBA, please let us know.
Upvote
0
Similar threads
- Question
- Question
