Question $8$

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

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

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

the value in $AG4,$ if the PROVINCE is $AB,$

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

otherwise the value in AG$6.$

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

In U$14,$ use the appropriate function to count how many values are less than $600.$ Format answer as comma style, $0$ decimal.

Blank $1$