Short Tips#0040: AND, OR, XOR,NOT functions
Tag: AND
Lesson#92: How to highlight a column value depending upon the other column values
Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …
Lesson#92: How to highlight a column value depending upon the other column values Read more »
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#56: How to make birthday reminder in excel
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more »
Lesson#49: Make a parent Gantt chart from a data table
Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …
Lesson#49: Make a parent Gantt chart from a data table Read more »
Lesson#39: Cool tricks to make automatically updating Gantt chart
Hi, friend today I will show you how to make an automatically updating Gantt chart without using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more »
Lesson#38: AND function in Excel
AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE then it returns TRUE. Syntax of that function is AND(logical1, logical2, ….) Example: Here I have shown an example where the values of the …