| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple criteria formula
I am trying to create muliple formulas for one column.
Column C - I have client Age Column G - This is going to be any value, however if the client is younger than 50 years of age, the max value is $15,000. If the client is above the age of 50, the max value is $20,000. Also, in column H, I need the max to be 4% of Column D divided by twelve (monthly income) Thank you Thank you very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Threaded Mode
