Tables

Hi Sharon

This is a problem you would also get when you copy the formula down in a normal range. Any figure in a formula would be replicated in all the subsequent rows. If you wanted some to receive 20% and some 10% then you would need to use an IF function in place of the straight calculation, and your table would have to contain some information that would indicate which rate would apply in each row

Hope this helps

Regards

Stephen