https://youtube.com/watch?v=0NdHzfCW9PIHow to use IFS function in excel. As you know, The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first…