Hello All,
I’m trying to work out how to create a formula to action the below.
4 Columns as below:
- Order Value (numbers column)
- Percentage (numbers column)
- Minimum Charge (formula column) (IF({Order Value}<1000,100,0)
- Total Charge (formula column)
If the Order Value column is $1000 or under then charge the Minimum Charge of $100.
If the Order Value column is $1000 or over then charge the Order Value column * Percentage column but do not include the Minimum Charge column (e.g. $1000 * 10% minus the Minimum Charge column = Total Charge Column)
Regards
Ryan