If this (Formula) or If that (formula)


I need a column to have more than one formula. For example. I have employees that work in different cities/counties. Based on where they work, there may be a City and County Withholding tax or just A City Withholding tax or just a county withholding tax.

A) I have an employee working in Madisonville - there is a city of Madisonville tax (2.5%) and a Hopkins County withholding tax (0.5%)

B) An Employee working in Hanson only has to pay the Hopkins Co Withholding tax (0.5%) So my Hopkins Co Column needs multiple "If" formulas.

For A) I have Location column that would say Madisonville and a formula =SUMIF(Location@row, "City Tax:Madisonville", [Total Pay]@row) * 0.025 for the Madisonville Column and =SUMIF(Lcoation@row, "City Tax:Madisonville", [Total Pay]@row) * 0.005 for the Hopkins Co Column.

But for Employee B I would need =sumif(Location@row,"City Tax:Hanson",[Total Pay]@row)*.005

How can I have both of these formulas in the same Hopkins Co Tax Column?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!