samedi 23 février 2019

Im really confused as to how i can use the choose function with the if statement to return a season

I'm using excel to create a formula that will calculate which season had more deliverers done by drivers. I'm doing an assignment and this is the original question.j. "Show if the Drivers were making more deliveries during the summer or during the Christmas time." Heres what i got so far but i did try,but i got really confused. =CHOOSE(MONTH(C2:N2,index(MAXIFS(

Heres a image of my spreadsheet my exel spreadsheet,as you can see the month are on the top and i want excel to choose the season based on the month with the highest deliveies made by drivers to show

Aucun commentaire:

Enregistrer un commentaire