I just need the equation to find these values in excel. How I see it, is 2 and functions in a nested if. I do not know how to have the separate outputs though

Promotion Code 1 Order No. Order Date 100051 1/2/2016 100052 1/2/2016 100053 1/2/2016 100054 1/3/2016 100055 1/10/2016 100056 1/10/2016 100057 1/10/2016 100058 1/10/2016 1000591/10/2016 100060 1/17/2016 Year Sales Organization 2016 Manchester Bike Store 2016 Manchester Bike Store 2016 Manchester Bike Store 2016 Bikes Studio St. Charles 2016 Bikes Studio Arch 2016 Bikes Studio Arch 2016 Bikes Studio Chesterfield 2016 Bikes Studio Forest Park 2016 Manchester Bike Store 2016 Bikes Studio Chesterfield Product MTB Light V-Brake Backfire 40 Stream N3 28" Devil Backfire 40 XT Pro Star Lady Bike 28 Backfire 40 Devil Devil Product Group Mountain Bike Mountain Bike City Bike Racing Bike Mountain Bike Trekking Bike Trekking Bike Mountain Bike Racing Bike Racing Bike Channel Sales Rep. Sales Quantity Revenue Discount Wholesale Bach 1649 164.9 Wholesale Bach 349 34.9 Internet Bach 1947 194.7 Wholesale Jobs 1699 169.9 Wholesale Karajam 3196 319.6 Internet Karajam 799 79.9 Wholesale Mozart 299 29.9 Wholesale Gates 6 4534 453.4 Internet Bach 1699 169.9 Internet Mozart 1699 169.9 Cost 1519.21 279.2 1557.6 1325.22 2428.96 607.24 227.24 3132.86 1325.22 1325.22 3. Use Requirement 3 worksheet to mark Promotion code cell "Summer Gala" if Revenue is greater than $4500 and Product Group is City Bike, mark "Ballroom" if Revenue is greater than $2500 and product group is Trekking Bike. Mark the rest "No Promotion