| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Need Help. I have a salary amount. And I have a pay schedule that is a
matrix. I have the lane/column and the step. I want to hold the step and move the lane until the salary is equal or greater that salary given. I can do an index and test and add 1 if less and just keep doing that...but, there should be a formula that might use the index and the goal seek function. any help appreciated. -- James D. Sheehan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula
Use Fill Series.
No formula required. Enter [step value] or zero into a cell. Edit Fill Series Columns Linear Step Value [step value] Stop Value [salary value] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Linear Mode
