Logical Function in Google Sheet
Logical functions - overview
Google Sheets provides logical functions to work with the logical values. The functions are AND, OR, IF, IFS. You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions...
