C
CandiC
My issue is that I have a cost sheet that has a tax code in cell E46 if the
labor is performed in IA, however if the work is performed in IL it is not
taxable. therefore in my spread sheet I have the total of material in E45 and
total labor in E47 both totalled in E48 and the standard tax rate identified
by user in E49. In cell E50 I have a total of E49 + tax to give me a total
price. However, In the case that I don't need to add tax to labor what is a
good way to split that up? If 46 is populated with a tax rate then have a
formula in E49 that will ignore the labor in E47 and add it to E50? Please
help.
Candi
labor is performed in IA, however if the work is performed in IL it is not
taxable. therefore in my spread sheet I have the total of material in E45 and
total labor in E47 both totalled in E48 and the standard tax rate identified
by user in E49. In cell E50 I have a total of E49 + tax to give me a total
price. However, In the case that I don't need to add tax to labor what is a
good way to split that up? If 46 is populated with a tax rate then have a
formula in E49 that will ignore the labor in E47 and add it to E50? Please
help.
Candi