Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |