formula
 

I would like to * A1 by .03 up to the first $20,000 but not over. Even if the
amount is under or over $20,000 in one box and the amount that is over
$20,000 * .02 in a other box
Thanks Roy

formula
 

One way:

B1: =MIN(A1,20000)*0.03
B2: =MAX(0, A1-20000)*0.02


An alternative that calculates it in one cell:

=SUMPRODUCT(--(A1{0,20000}),(A1-{0,20000}),{0.03,-0.01})

In article ,
"Roy E" <Roy wrote:

I would like to * A1 by .03 up to the first $20,000 but not over. Even if the
amount is under or over $20,000 in one box and the amount that is over
$20,000 * .02 in a other box
Thanks Roy

formula
 

Something like this:

'amount under 20.000 x 0,3
=MIN(20000;A1)*0,3

and

'amount above 20.000 x 0,2
=(MAX(20000;A1)-20000)*0,2

--
Ronald Ferdinandus
http://www.ro-pay.nl


"Roy E" wrote:

I would like to * A1 by .03 up to the first $20,000 but not over. Even if the
amount is under or over $20,000 in one box and the amount that is over
$20,000 * .02 in a other box
Thanks Roy

formula
 

Thank you JE and Ronald

"RonaldF" wrote:

Something like this:

'amount under 20.000 x 0,3
=MIN(20000;A1)*0,3

and

'amount above 20.000 x 0,2
=(MAX(20000;A1)-20000)*0,2

--
Ronald Ferdinandus
http://www.ro-pay.nl


"Roy E" wrote:

I would like to * A1 by .03 up to the first $20,000 but not over. Even if the
amount is under or over $20,000 in one box and the amount that is over
$20,000 * .02 in a other box
Thanks Roy