00:00This is how you calculate percentage based on criteria, like for example, in my student test result data set here,
00:06if Matthew's second semester score were to drop to 55, it would result in negative 26% lower than his
00:13first semester score of 74.
00:15Well, let's learn.
00:16We'll start off with using a VLOOKUP, which looks for Haley's test result in the first semester, which is going
00:22to return a value of 98.
00:23Now, if we divide second semester result with the output from the VLOOKUP and subtract by 1, that will give
00:30us the percent change.
00:32Now apply the same formula for the rest of the row.
00:35Okay, let's test it.
00:36If Liam were to get 99 in his first semester, his percent change would drop to minus 1%.
00:43And likewise, if Noah were to improve his second semester score to 99, his percent change would improve to 3%.
