Apply the condition as C4=D4 (TOTAL SEATS=SEATS SOLD) than in the double quotes, type the text as” BUS BOOKED.”.We are going to apply the above condition by using Multiple IFS.Now apply the Multiple IF function by checking the condition if TOTAL SEATS=SEATS SOLD then we need to get the status as “BUS BOOKED” or if TOTAL SEATS are less than SEATS SOLD, we need to get the status as “OVERBOOKED”, or else we will mention the status as “SPACE AVAILABLE.”.First, select the cell E4, which is nothing but the Status column.Here in the status column, we will use the Multiple IF function by following the step-by-step procedure. The online booking status example is shown below. In such cases, we can use the Multiple IFS function to derive the output. Consider the below example where we have Online Bus Ticket Booking System where we need to know the booking status whether all the seats are booked or not. In this example, we will learn how to use the multiple IF function by using the simple example. In the below example, we will see how to apply multiple IFS. We can use multiple IFS statements in excel to check two or more conditions at a time by using the same IF condition syntax. Apply the formula and press enter so that we will get the output as follows.Here we used the IF condition by checking if 20>100, then excel will return the status as “FAIL”, or else it will return “PASS.”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |