Forum Discussion

TahliF's avatar
TahliF
Copper Contributor
Mar 28, 2021

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

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

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

Resources