if statements help

[Smurphy]

I have a spreadsheet for insurance.
Min benefit in E1 is $10,000.00.
Max benefit in E2 is $90,000.00.
Wage Value is D6.
The formula I am trying to use is:
=IF(D6*1.5>$E$2,$E$2,D6*1.5),IF(D6*1.5<$E$1,$E$1,D6*1.5)
It does not work.

For example: wage in D6 is 110,000.00. 110,000.00 x 1.5 = 165,000.00. I
want return of 90,000.00.
If wage in D6 is 3,700.00. 3,700.00 x 1.5 = 5,550.00. I want return of
10,000.00.
If wage in D6 is 30,000.00. 30,000.00 x 1.5 = 45,000.00. I want return
of 45,000.00.
Please help.
Forever trying to learn.

 

[JE McGimpsey]

One way:

=MAX(MIN(D6*1.5,E2),E1)

 

[flummi]

This is your formula as it should work:

=IF(D6*1.5<=$E$1,$E$1,IF(D6*1.5>=$E$2,$E$2,D6*1.5))

Hans