| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas with If/ and results
I am trying to create formulas in order to populate a Group Insurance
Election Form. I am having trouble with how to cap. a maximum limit if the result of the calculation is $9000. For example LTD Monthly benefit is 60% of Monthly Salary. So, I have "I2" Annual Salary / 12 * 0.6. But, then I need to have the results that exceed $9,000/mth max. out at $9,000. and if they are < 9,000 I need to have the actual results show. I tried to incorporate an "IF" command but, it is not working. ex. =(I2/12*0.6),IF(Annual Salary180,000, 9,000, 0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining formulas and results HELP!! | New Users to Excel | |||
| Sum of all formulas in one column? | New Users to Excel | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Threaded Mode
