Formulas - IF This then do this calculation
Hoping someone can help! I want to do a formula IF Contract ASV is less than 100000, then multiply Contract ASV by .20 and put that amount in the Rev Share 20% of per year ASV in USD field, but IF Contract ASV is greater than 100000, then multiply Contract ASV by .1 and put in the Rev Share 10% of per year ASV in USD column.
Seems like I would need separate formulas in each of the columns, one for the 20% column and one for the 10% column, and then for the one that it is not applicable to the number showing would be zero for that column and the returned value would be in the other column.
I have looked through quite a few articles, but have not found anything where you are doing a calculation.
Help Article Resources
Check out the Formula Handbook template!