Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to write a statement that compares to cells and assigns a value.
there is a lot of data, and I am not certain that it can be done, any help would be appreciated, ... this is what I am working with ... 70% pay scale: 1 - 500 hrs worked / entry level 80% pay scale: 501 - 1000 hrs worked and 24 hrs or more training courses 90% pay scale: 1001 - 1500 hrs worked and 48 hrs or more training courses 95% pay scale: 1501 - 2000 hrs worked and 48 hrs or more training courses 100% pay scale: 2001 + hrs worked and 72 hrs or more training courses -AC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
"IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
How do I sum percentages calculated from IF statements? | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |