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.

Also, I would like to learn more about using scripts.

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

Thanks very much!

David

Try:

Case (

BRBW Comm < 15 ; 15;

BRBW Comm > 75 ; 75;

/* Else */ BRBW Comm

)

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

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 September 5, 201213 yr by comment

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

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

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.

 

Thanks for your help!

 

David

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
)

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

Thanks as always!  Really appreciate it!