On Aug 19, 12:54 pm, YY san. wrote:
Hi, any help appreciated.
A total cost value is used to calculate a tax value of 5%. Where tax is one
of the item contributing to the total cost.
How can calculate the tax amount without entering into a circular reference
error?
Thanks!

Put SUM info into the tax line to add up all the other appropriate
lines, multiplied by 5%. Then do your final sum at the bottom.

So maybe tax is in E100:
=SUM(E4:E99)*.05

And then the TCV is:
=SUM(E4:E100)