Formula help, please

[R0nseal]

Hi,

I don't really know how to describe this too well, but here goes and I hope someone can help me.

I have a cell which can have a number in. The number could be for this example, 15000.

I want to then have a formula which will only ever take the first 10000 and multiply that by 0.45
and then a second formula which will take anything from 10001 and multiply anything from 10001, in this example up to the 15000 and multiply it by 0.25.

so I would have two cells, both that look at the cell which contains the 15000,
and the 1st cell would give me the result 4500 in this example, (1000*0.45)
and the 2nd cell would give me the result 1250, in this example. (5000*0.25)

Can anyone help me pls?

Thanks
Dan

 

[Joe4]

If your value is in cell A1:

1st formula: =MIN(A1,10000)*0.45
2nd formula: = MAX(0,A1-10000)*0.25

 

[Scott T]

Book1
	A	B	C
1	15000	4500	1250
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A1<=10000,A1*0.45,10000*0.45)
C1	=IF(A1>1000,(A1-10000)*0.25,0)

If you would rather have the cell blank if the number is under 10000 change the 0 to "" in the formula in C1

=IF(A1>1000,(A1-10000)*0.25,"")

 

[R0nseal]

If your value is in cell A1:

1st formula: =MIN(A1,10000)*0.45
2nd formula: = MAX(0,A1-10000)*0.25

Thank you!

 

[Joe4]

You are welcome!