Using Google Sheets Multiple If Then Formula for Complex Conditions

When working with online booking systems, it's common to encounter situations where you need to check multiple conditions to determine the booking status. For instance, consider a bus ticket booking system where you want to know if all seats are booked or not. In such cases, using the Multiple IFS function in Google Sheets can be a game-changer.

The Multiple IFS function allows you to check two or more conditions at once, making it an ideal solution for complex scenarios. Let's dive into an example to illustrate how this works.

Example: Online Bus Ticket Booking System

Suppose we have an online bus ticket booking system where seats are booked based on the availability of the bus. We want to use Google Sheets to check if all seats are booked or not. To do this, we can create a formula that checks multiple conditions and returns a corresponding status.

Here's how you can apply the Multiple IFS function:

=IFS(A1:A5;'>100', 'FAIL', A1:A5;'>50', 'PARTIALLY BOOKED', ISBLANK(A1:A5), 'UNAVAILABLE')

In this example, we're checking three conditions: if the seat availability is greater than 100 (FAIL), if it's between 51 and 99 (PARTIALLY BOOKED), or if the cell is blank (UNAVAILABLE). The IFS function will return the first condition that is true.

Applying the Formula

To apply this formula, simply type it into a cell in your Google Sheet and press Enter. You'll see the output as follows:

FAIL

In this example, since there are no seats booked (i.e., the availability is less than 50), the formula returns 'FAIL'. If you were to update the data to reflect partially booked seats or unavailable seats, the formula would return accordingly.

The Multiple IFS function in Google Sheets is a powerful tool for handling complex conditions. By using this function, you can create formulas that check multiple conditions and return corresponding outputs. In the example above, we've seen how to use the IFS function to determine the booking status of bus seats. With practice, you'll be able to apply this formula to various scenarios, making it an essential tool in your Google Sheets toolkit.

Google sheets multiple if then formula