| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Student Creating Formula
Trying to calculate Qtr 401k mtch. Mtch is 100% of the first 3% of deferred
compensation and 50% of the next 2%. D: Defer %, E: Salary, F: Deferred Amount =IF(DATEDIF(C2,DATE(YEAR(TODAY()),12,31),"y")<21,0 ,(MIN(E2*0.04,F2) + MIN(E2*0.03, F2)) / 2) Example: Ann elects 1% total deducted is 180.02. Qtr Match is 180.02 Pleas help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hi Everyone! Im a Student so please be kind... | Charts and Charting in Excel | |||
| Pivot table and formula help??STUDENT NEED HELP.... | Excel Discussion (Misc queries) | |||
| how to match Id and Student ID | Excel Worksheet Functions | |||
| student directory | Excel Discussion (Misc queries) | |||
| Trouble with formula on Student 2006 learning essentials template | Excel Worksheet Functions | |||
Threaded Mode
