IF Formula Based on Selected Quarter
Hi, I would like to write a formula that selects the appropriate sales tax rate with each quarter. I think I may be missing something basic when if comes to IF formulas...Does it matter if the sales tax column was created as a dropdown list? Is there a limit to the length of this formula if I were to add on with future tax rate changes?
=IF([Payments in Quarter]@row = "Q.1.19", "7.10%"), =IF([Payments in Quarter]@row = "Q.3.18", "6.85%"), =IF([Payments in Quarter]@row = "Q.2.19", "7.25%")
Thanks,
K
Comments

You don't need so many brackets around each IF formula or the extra = signs. Also do you want the result to display as text? Right now, it will display 7.10% as text, which will make it difficult if you are trying to use that in another formula. Just remove the quotes and format your column as a %.
Try:
=IF([Payments in Quarter]@row = "Q.1.19", .0710, IF([Payments in Quarter]@row = "Q.3.18", .0685, IF([Payments in Quarter]@row = "Q.2.19", .0725)

Figured out their is a conflict of interest with a manual dropdown and a formula in this row, so I'll need to think further on its function.
Thanks for helping me with the Sales Tax formula, works very well!
Help Article Resources
Categories
Check out the Formula Handbook template!