| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to another forumula?
We would like to have a formula that will calculate differently based on
Tenure of our staff. Column B will hold the Tenure. So say cell B5 equals 6 or greater, then =IF(C5=17.5%,5,IF(C5=16.25%,4,IF(C5=14.25%,3,IF (C5=13%,2,IF(C5=0,1,"N/A"))))) and if B5 equals 5 then =IF(C5=16.5%,5,IF(C5=15.25%,4,IF(C5=13.25%,3,IF (C5=12%,2,IF(C5=0,1,"N/A"))))) and so on down to B5 equaling down to 1 or less. How do I do this? Forgive me for being kind of a hack. Max had tried to help earlier but had a part of the formula I didn't understand. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a look up forumula I haven't seen before | Excel Worksheet Functions | |||
| I Need a forumula or VBA code | Excel Discussion (Misc queries) | |||
| If more than condition forumula | Excel Worksheet Functions | |||
| Forumula help using Countif | Excel Worksheet Functions | |||
| Help with FORUMULA | Excel Discussion (Misc queries) | |||
Threaded Mode
