If statement with tiers

Hello -

I am looking for a little assistance with a IF statement. Basically I have 3 tiers and I want a formula that allows someone to enter a number in a box and it applies that number across the tiers based on the parameters of the tier. See example below:

	A	B	C	D	E
1	0-100	100		Enter Number	165
2	>100-150	50
3	>150	15
4

I think my problem is if the number is 80 which would not break into the next tier the numbers get crazy but I think it's because im using hard numbers in the formula versus a cell for reference. Below are my formulas and I know my mistake is the formula structure but not sure how to correct.

Here is my formulas:

B1 = IF(E1>100,100,E1)

B2 = IF(150>E1>100,E1-100,0)

B3 = IF(E1>150,E1-150,0)

Open to thoughts

Thanks,

Formulas and Functions