How to create a mega formula -1/2

Excel Formula challenge #3 – with solution

Excel Formula Challenge #2

Excel Formula Challenge #1 -Solution uploaded