Hi @Garfield !
These formulas are correct! What you want to do is combine the formulas into one statement.
If we think about the basis of the IF statement, we want to start with the rule following with a comma, stating if that rule is true, following with a comma, and then what happens if that rule is false.
I do not believe that you need the MAX statement either. That is used best with multiple number columns that you are comparing.
What I believe that your statement should be is the following:
IF({SQFT Stamped Concrete}>300, MINUS(MULTIPLY(5,{A}),300), 1200)
This statement says if the concrete is more than 300, multiply “a” by 5 than subtract 300, otherwise show 1200.
If you are using MAX to take the highest value from multiple columns that is where you would use the MAX function like the following:
IF(MAX({Number 1},{Number 2})>300,MINUS(MULTIPLY(5,{A}),300), 1200)
This statement says if the largest number between number column 1&2 is greater than 300, multiply “a” by 5 and then subtract 300, otherwise show 1200.
One more scenario (just in case I am reading this wrong), If you are using {a} as the answer to your first statement in the MAX statement, you will want to use this formula:
IF(MAX({Number 1},{Number 2})>300,MINUS(MULTIPLY(MAX({Number 1},{Number 2}),5),300), 1200)
This statement says if the largest number between number column 1&2 is greater than 300, multiply the largest value between Number 1&2 by 5 and then subtract 300, otherwise show 1200.
Hope this helps!