if then

  • Thread starter Thread starter CandiC
  • Start date Start date
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
 
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
 
Back
Top