Circular Reference-tax value on total expense

[YY san.]

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!

 

[Spiky]

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)

 

[David Biddulph]

=A2*5%/(1+5%)