Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula?
I am trying to have excel return a certain value based on a series of
date ranges. I want the value to return true or a specific number if it returns a number less than the max, but if greater than a max number for the period I want it to return only the max number. An example: 01/01/2008-12/31/2008=3000, 01/01/2009-12/31/2009=3600. So lets say the persons salary or wage for 2008 was 2888.00, then I would want the formula to return 2888.00. But if the salary for 2008 was 3700.00 I would want the value to return 3000. Can anyone suggest anything? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Need Help With Array Formula | Excel Discussion (Misc queries) | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Array Formula | Excel Worksheet Functions |