Excel Formula not working…
I hope this is where I post this question?
I have a MASSIVE formula that I using to accrue vacation time based on different criteria. Basically I am wanting to use the same formula that I’m using now, just add something to it. I can not get it to work however.
My problem- I need to execute a formula for an employee only IF the employee has worked 140 hours for the month. I can download the employee’s hours from an ODBC so that is no problem. My issue is how do I say in the formula- =IF (A3 >= 140)THEN,
massive formula:
————————————————–=IF(AND(DAY(TODAY())>=DAY(A3),YEAR(TODAY())=YEAR(A3)),(MONTH(TODAY())-MONTH(A3))*3.34,IF(AND(DAY(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())
