Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |