# Simple Script to set minimum and maximum commissions on a sale

## Recommended Posts

I have commissions that range from a few pennies to hundreds of dollars.

I calculated the commissions with a simple formula and it gives me the commission amounts.

I want to set a minimum commission of, say \$15 and a maximum commission of \$75.

I used this: If ( BRBW Comm < 15; 15 ) and got all commissions < 15 to be set at 15.

However, I wasn't able to add to that the part about if the commission is > 75, set all those to \$75.

Not sure what to use the Case or the If statement.

Can you suggest a good resource for quickly learning scripting formulas?

Thanks very much!

David

##### Share on other sites

Try:

```
Case (

BRBW Comm < 15 ; 15;

BRBW Comm > 75 ; 75;

/* Else */ BRBW Comm

)```

##### Share on other sites

If the minimum commission is 15 then there will be none < 15. If the maximum is 75 there will be none > 75.

##### Share on other sites

Try =

```Case (

commission < 15 ; 15 ;

commission > 75 ; 75 ;

commission

)```
```

or =

```
`Min ( Max ( 15 ; commission ) ; 75 )`
```

---

BTW, this is a calculation, not a script - and it could be done all in the same field, say =

```
`Min ( Max ( 15 ; <your commission formula> ) ; 75 )`

Edited by comment

##### Share on other sites

Hi dr, and welcome to the forum,

Give us more detail regarding your breaking points.

0 - 15 = 15

16 - 25 = 25

26 - 50 = 50

and so on.

Lee

##### Share on other sites

Thanks very much for the quick response! I really appreciate it.

I need to think about this a bit . . . about the different levels that would be most suitable . . . will post later

##### Share on other sites

Hi,

I've been using this:

Case (
BRBW Comm < 15 ; 15;
BRBW Comm > 75 ; 75;
/* Else */ BRBW Comm
)

But I want to change it to this:

If price is \$0 to \$15 commission is \$5

\$15-\$30, \$7.50

\$30-\$50, \$10

etc.

and then when I get to \$250 I want it to be a percent and not a fixed \$ value:

\$250-\$500, 15%

\$500-\$1000, 20%

>\$1000, 25%

Not sure how to up these ranges.

David

##### Share on other sites
```Case (
price < 0 ; "?" ;	// error
price ≤ 15 ; 5 ;
price ≤ 30 ; 7.5 ;
price ≤ 50 ; 10 ;
// ...
price ≤ 250 ; 30 ;	// value "30" for example
price ≤ 500 ; price * .15 ;
price ≤ 1000 ; price * .2 ;
/* Else */ price * .25
)```

##### Share on other sites

It probably shouldn't be a script or calc at all; but rather a lookup from a commission rate table.

##### Share on other sites

Thanks as always!  Really appreciate it!

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Who Viewed the Topic

1 member has viewed this topic: