Short Tips#0040: AND, OR, XOR,NOT functions
Tag: OR
Lesson#86: Logic Gates in Excel
So I show you here how the logic gates can be configured in Excel. AND gate Q = A AND B So here the formula for getting AND result will be =IF(AND(J20=1,K20=1),1,0) NAND gate Q = A NAND B So here the formula for …
Lesson#77: Scope the breakup program schedule and explain the formula
Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …
Lesson#77: Scope the breakup program schedule and explain the formula Read more »
Lesson#40: OR function in Excel
OR function checks whether any of the arguments are TRUE then it returns TRUE or it will return FALSE.Syntax of that function is OR(logical1, logical2, ….)Example: Here I have shown an example where the values of the C column are going to …