How did you find question 14?
15 marks! :?
I cudn't do it.. :| :|
14)In cell D15 enter a formula that will display the rate charged for each delivery for the
supplier selected in cell A2. This formula will look up the chosen supplier in the
supplier table and choose the correct rate, depending on the number of properties for
that area and return the corresponding rate from the supplier table.
For example:
If the supplier chosen was X Mail and the area was Cambridge, this should return the
rate for this supplier for a town of 27000 properties which would give a rate of 0.002
for each delivery.
15 marks! :?
I cudn't do it.. :| :|
14)In cell D15 enter a formula that will display the rate charged for each delivery for the
supplier selected in cell A2. This formula will look up the chosen supplier in the
supplier table and choose the correct rate, depending on the number of properties for
that area and return the corresponding rate from the supplier table.
For example:
If the supplier chosen was X Mail and the area was Cambridge, this should return the
rate for this supplier for a town of 27000 properties which would give a rate of 0.002
for each delivery.