Question

change the calculation in e5 to also include the state before the postcode, e.g. nsw2007. copy the formula down. what is the value of check digit 5? please enter just the number

Answer 1

To include the state before the postcode in the calculation, use the CONCATENATE function in Microsoft Excel.

Step-by-step explanation:

To include the state before the postcode in the calculation e5, you would need to use the CONCATENATE function in Microsoft Excel. Assuming that the state is in cell D5 and the postcode is in cell E5, you can modify the formula to CONCATENATE(D5,E5). This will combine the state and postcode values together. Copy the formula down to apply it to the remaining cells. To determine the value of check digit 5, it is necessary to have more information about the calculation being used.