Project Description:
Please help with the formula below. Explain it to me:
=IF(DATEDIF(D6,('2010'!$F$10),"d")<90,0,IF(DATEDIF(D6,('2010'!$F$10),"M")<=36,IF(DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$F$8)+D13>('2010'!$F$6),('2010'!$F$6),DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$F$8)+D13),IF(DATEDIF(D6,('2010'!$F$10),"M")>60,IF(DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$L$8)+D13>('2010'!$L$6),('2010'!$L$6),DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$L$8)+D13),IF(DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$I$8)+D13>('2010'!$I$6),('2010'!$I$6),DATEDIF(DATE(YEAR(('2010'!$F$10)),1,1),('2010'!$F$10),"D")/30*('2010'!$I$8)+D13))))
I will provide the Excel file by email to the winner, after project is accepted. SEE ATTACHMENT.
Excel Additional Files: IF+Dated+Formula.docx
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.
