Tag: XOR

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

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips Tagged with AND, NOT, OR, XOR

Lesson#86: Logic Gates in Excel

By Puspendu Roy Karmakar Posted on June 24, 2018 Posted in Excel Funtions Tagged with AND, NOT, OR, XOR

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#86: Logic Gates in Excel Read more »

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

Home
About
Contact
Privacy Policy

Loading…