Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complicated formula?
Hello everyone....
I need some help. I have a column of dates and a column of income amounts. I have multiple sheets in the workbook with income tables by year by percentage. I need to create a formula to look in column F and pull data from the sheet with the corresponding year. I also need the formula to look at the income amount (Column G) and determine what percentage it is based on the table. So if the date is sometime in 1999 and the income is within a certain range, the cell would print 30%. If the date is in 1999 and the income is in a higher range of amounts, it would print 50%. Or if the year is 2000 or 2004 or whatever. I only have 3 ranges of income to work with: 30%, 50% and 80% but I have years 1996-2007. This seems pretty complicated to me and if it's a huge hassle, please don't lose any sleep over it. I can always come up with a plan B. Thank you all for your help in advance. Leigh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help doing complicated formula | Excel Worksheet Functions | |||
Complicated formula | Excel Discussion (Misc queries) | |||
complicated formula help | Excel Worksheet Functions | |||
complicated if then formula...need help | Excel Discussion (Misc queries) | |||
Complicated Formula | Excel Discussion (Misc queries) |