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

%3CLINGO-SUB%20id%3D%22lingo-sub-2240045%22%20slang%3D%22en-US%22%3ECreating%20a%20nested%20if%20formula%20to%20calculate%20stamp%20duty%20based%20on%20purchase%20state%20and%20purchase%20price%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2240045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%E2%80%99m%20trying%20to%20nest%20different%20stamp%20duty%20calculation%20methods%20based%20on%202%20cell%20values.%20The%20state%20and%20the%20purchase%20price.%20I%20have%20the%20calculations%20for%20each%20states%20stamp%20duty%2C%20but%20can%20only%20get%202%20states%20to%20work%20together%20and%20am%20having%20trouble%20combining%20them.%20Can%20anyone%20help%20me%20work%20out%20a%20way%20to%20do%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2240045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2240145%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20nested%20if%20formula%20to%20calculate%20stamp%20duty%20based%20on%20purchase%20state%20and%20purchase%20price%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2240145%22%20slang%3D%22en-US%22%3Eyou%20can%20use%20if(%20and%2For(cell%201%2C%20cell%202))%2C%20if%20you%20show%20us%20your%20file%2C%20we%20can%20give%20more%20details%20%26amp%3B%20your%20requirement%3C%2FLINGO-BODY%3E
Occasional Visitor

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!!