if statements help
 

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,D 6*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.


--
Smurphy


------------------------------------------------------------------------
Smurphy's Profile: http://www.excelforum.com/member.php...o&userid=31233
View this thread: http://www.excelforum.com/showthread...hreadid=509020

if statements help
 

One way:

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

In article ,
Smurphy wrote:

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,D 6*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.

if statements help
 

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