Question: In U 1 7 use NESTED IF functions to enter: the value in AG 2 , if the PROVINCE is ON , the value in
In U use NESTED IF functions to enter: the value in AG if the PROVINCE is ON the value in AG if the PROVINCE is BC the value in AG if the PROVINCE is AB the value in AG if the PROVINCE is MB otherwise the value in AGCopy the nested functions to the rest of the cells in the column.In U use the appropriate function to count how many values are less than Format answer as comma style, decimal.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
