Circular Reference-tax value on total expense
 

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!

Circular Reference-tax value on total expense
 

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)

Circular Reference-tax value on total expense
 

=A2*5%/(1+5%)
--
David Biddulph

"YY san." wrote in message
...
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!