Tag: AND

Short Tips#0040: AND, OR, XOR,NOT functions

Tagged with: , , ,

Lesson#92: How to highlight a column values depending upon the column values next to it

Hello Friend! I am back again with my another post. This post is about Conditional Formatting. Here I will show how to highlight a column values depending upon the column values next to it. In this above picture I am

Tagged with: ,

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

Tagged with: , , ,

Lesson#77: Scope breakup program schedule and explaining formula

Here I have got a case when my colleague was working with a project schedule. He had a schedule with start date, end date and scope and he had to breakup the scope month wise. With a long schedule this

Tagged with: , , , , , , , ,

Lesson#56: How to make birthday reminder in excel

Here I am having a employee database and I have to make a birthday reminder from it. It needs a little tricks to make it. I have inserted to columns beside the DOB column, Upcoming Birthdays this Month and Birthday Today In

Tagged with: , , , , , ,

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

Tagged with: , , , , ,

Lesson#39: Cool tricks to make automatically updating gantt chart without using excel chart

Hi friend today I will show you how to make an automatically updating gantt chart without using Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, Days (shown in picture

Tagged with: , ,

Lesson#38: AND function

AND function is used to satisfy multiple condition. 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 F column

Tagged with: ,
Top