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

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

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

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

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

otherwise the value in AF$6.$