Formula Help - IF statements

Platform discussions
1

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

1 Like
2

What about IF({Order Value}<1000,100,({Order Value}*{Percent}))

It will return EITHER, the $100 or the total order * percent

3 Likes
3

Cheers that worked perfectly :slight_smile:

1 Like
4

Great! Glad I could help!

Desiree - www.thecleverclovers.com