Using Boolean algebra as switching algebra, complex circuits are expressed so that they can be evaluated mathematically.

Excel Boolean logic: How to sift spreadsheet data using AND, OR, NOT, and XOR Excel logical functions make it easy to find the data you want, especially in huge spreadsheets.