DeMorgan Theorem & Excel Formula

  • Context: High School 
  • Thread starter Thread starter Newtonian_gravity21
  • Start date Start date
  • Tags Tags
    Excel Formula Theorem
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
1 reply · 5K views
Newtonian_gravity21
Messages
3
Reaction score
0
=IF (C1>1,"yes","No") I think that's right :rolleyes:

Does Demorgan Theorem use a simular logic when doing calculations for logic gates, using true and false properities?
 
Mathematics news on Phys.org
Demorgan Theorem states that you can change the AND to OR and vise versa by using NOTs. Such as:
A AND B = NOT (NOT A OR NOT B)
A OR B = NOT (NOT A AND NOT B)

Where does this come from? I see it when using loops in programming. A WHILE loop needs a condition to continue looping whilst a REPEAT loop needs a condition to stop looping. They use opposite logic. Now the problem comes when you want to use a different loop which has a compound condition.

EG WHILE (end of file not reached) and (user did not press esc) read file

Now which is the equivalent expression to make a REPEAT loop?

REPEAT read file UNTIL (end of file reached) OR (user pressed esc)

See? We used DeMorgans except that we did not use the outer NOT because other wise it would have returned the same result as with the first loop. Simple huh?