Creating a nested if formula to calculate stamp duty based on purchase state and purchase price

Copper Contributor

I’m trying to nest different stamp duty calculation methods based on 2 cell values. The state and the purchase price. I have the calculations for each states stamp duty, but can only get 2 states to work together and am having trouble combining them. Can anyone help me work out a way to do this?

2 Replies
you can use if( and/or(cell 1, cell 2)), if you show us your file, we can give more details & your requirement
Share some sample data along with criteria, help us to fix the issue!!