Forum Discussion
help with creating a formula with multiple functions and/or nesting formula
I am stuck and need help below is what I am trying to achieve This was my original formula to calculate the sales tax because if the purchase price is below a certain amount the tax is one value ...
There are in Excel often multiple ways to accomplish the same objective.....in this case, I think you'd be better served by one of those other routes, rather than trying to concoct a nested IF formula (which can get very convoluted and hard to maintain).
Could you post a copy of your spreadsheet--using either OneDrive or GoogleDrive, and then posting a link here? That way we could see how you have the existing data arrayed and suggest several ways to do what you're wanting to do. Also, please, let us know which version of Excel you're using.