| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function based on True result with large formula.
I have a massive formula that I use to figure up vacation accumulation for
certain employees. Now I have to run the same formula EXCEPT it only needs to be ran if the employee has worked 140 hrs. How can I incorporate that into my formula??? Below is my formula- IF A2 is =140 then formula: ------------------------------------------------------------------------------- =IF(AND(DAY(TODAY())=DAY(A3),YEAR(TODAY())=YEAR(A 3)),(MONTH(TODAY())-MONTH(A3))*3.34,IF(AND(DAY(TODAY())<DAY(A3),YEAR(T ODAY())=YEAR(A3)),(MONTH(TODAY())-(MONTH(A3)+1))*3.34,IF(AND(YEAR(TODAY()YEAR(A3)), (YEAR(TODAY())-YEAR(A3)<10),DAY(TODAY())=DAY(A3)),(((MONTH(TODAY ()))*(80/12))+((12-MONTH(A3))*3.34)+((YEAR(TODAY())-(YEAR(A3)+1))*80)),IF(AND(YEAR(TODAY()YEAR(A3)),( YEAR(TODAY())-YEAR(A3)<10),DAY(TODAY())<DAY(A3)),(((MONTH(TODAY( ))-1)*(80/12))+((12-MONTH(A3))*3.34)+((YEAR(TODAY())-(YEAR(A3)+1))*80)),"N/A")))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems creating a result based on 2 cells being true.. | Excel Worksheet Functions | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| True number as the result to an If-Then function | Excel Discussion (Misc queries) | |||
| Can Excel operate a function based on a true or false result? | Excel Worksheet Functions | |||
Threaded Mode
