How to Use Islogical Function in Excel

This wikiHow teaches you how to check for a logical value (such as true or false) in Excel using the ISLOGICAL function.

Steps

1
Open Microsoft Excel. If you're using Windows, you'll find it in the Windows menu under “Microsoft Office.” If you have a Mac, you'll find it in the Applications folder.
2
Open the spreadsheet that contains your data. To do this, press Ctrl+O (Windows) or ⌘ Cmd+O (macOS), then double-click the spreadsheet file.
3
Double-click the cell where you want to place the function.
4
Type =IS. A list of suggested functions will appear.
5
Double-click ISLOGICAL. The function should now appear in the cell.
6
Click the cell with the value you wish to use. This pastes the cell's coordinates into the cell with the function.
7
Press ) to close the formula.
8
Press ↵ Enter or ⏎ Return. The result of the function will appear in the current cell.
9
Hover the mouse cursor over the cell's bottom-right corner. The cursor should turn into a crosshair symbol.
10
Drag the crosshair down to automatically fill additional cells. You can drag it down all the way to the end of your data to run the formula against every cell in the column that contains the values.