billybernadette
New Member
- Joined
- Oct 16, 2017
- Messages
- 2
Explain formula:
IF(NOT(AND(1>1, 2>1)), 1, 2) + IF(NOT(OR(1>1, 2>1)), -1, 1)
IF(NOT(AND(1>1, 2>1)), 1, 2) + IF(NOT(OR(1>1, 2>1)), -1, 1)
-
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.
Excel question
- Thread starter billybernadette
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,373
- Office Version
- 365
- Platform
- Windows
It looks like it's to explain OR and AND and NOT.
I'll show you how to do the first one, then you should know how to do the second one
The easiest way to figure out things like this is to break them down piece by piece.
So first:
AND(1>1,2>1) will return FALSE because they have to both be true to return TRUE and 1 is not greater than 1.
NOT reverses the result of the boolean (TRUE or FALSE) expression.
So now the value is TRUE
and will therefore return 1 from the first expression.
I'll show you how to do the first one, then you should know how to do the second one
The easiest way to figure out things like this is to break them down piece by piece.
So first:
AND(1>1,2>1) will return FALSE because they have to both be true to return TRUE and 1 is not greater than 1.
NOT reverses the result of the boolean (TRUE or FALSE) expression.
So now the value is TRUE
and will therefore return 1 from the first expression.
Upvote
0
