Matthew_Barton - profile

Matthew_Barton · Mar 21, 2020

I’m currently migrating from using google sheets to Airtable, I have a majority of my formulas working, however, I need assistance with this: =IFS(A2>1000001,A254%,A2>=400001,A251%,A2>=200001,A247%,A2>=100001,A242%,A2>=80001,A237%,A2>=60001,A234%,A2...

Matthew_Barton · Mar 23, 2020

Thanks for the feedback and guess what? It works, this is the formula in effect: IF({Deal : Automated Value} > 1000001, {Deal : Automated Value} * 0.54, IF({Deal : Automated Value} > 400001, {Deal : Automated Value} * 0.51, IF({Deal : Automated Value...

User Statistics

User Activity

Formula Writing Help Needed - IFS

Re: Formula Writing Help Needed - IFS