Question $7$

In U$17$ use NESTED IF functions to enter:

the value in AE$2,$ if the PROVINCE is ON$,$

the value in AE$3,$ if the PROVINCE is BC$,$

the value in AE$4,$ if the PROVINCE is AB$,$

the value in AE$5,$ if the PROVINCE is MB$,$

otherwise the value in AE$6.$

Copy the nested functions to the rest of the cells in the column.

In $U14,$ use the appropriate function to count how many values are greater than $400.$ Format answer

as comma style, $0$ decimal.

Blank $1$

Blank $1$

Last saved $1$:$03$:$49$ AM