| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make an IF statement have multiple TRUE answers?
I am trying to write a formula for giving employees a merit increase on the
year anniversary of their start date. I tried to write IF the current date-start date=1,2,3, or 4, then multiply their current salary by the merit %. The dates are formatted as 2007.01, 2006.08, etc. It will let me do it if it =1, but not the other years. I am forecasting for the next 5 years. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function for multiple answers? | Excel Worksheet Functions | |||
| IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
| How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
| How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
