I will also create the Excel sheet for you to see the formula in action :)
To answer your 3 questions:
Here is the sample file to see this formulas in action:
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
Thank you for using our service. If you need assistance in the future, you can request me any time by posting a new question starting with "For Jess M" so that I can assist you immediately.