if then

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
 
B

Bernard Liengme

Your question seems to say that labour is tax-free in IL but material are
not
If E46 is Y for 'add tax to labour' and N for 'no tax on labour)
=E45*(1+E49 ) gives the materials plus tac cost
=E47*(1+E49*(E46="Y")) gives the labour plus tax (when applicable)

So what I would use in E50 is:
=E45*(1+E49 ) +E47*(1+E49*(E46="Y"))

Note that (E46="Y") will evaluate to either TRUE or FALSE. When this value
is multiplied by the tax rate in E49
the TRUE/FALSE is treated as 1/0 so the result is E49*(E46="Y") is with
equal to E49 or to zero
best wishes
Bernard Liengme
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top