akreidler
03-07-2013, 01:18 PM
Not sure where to put this question but I am looking to nest another If statement inside an array formula where if the Array Formula answer = "01/01/2020" then I want it to return "No Start Date". Here is my array formula:
{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}
So here is the formula I would want to see:
If({=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}="01/01/2020","No Start Date",{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}
Hope someone can help me!
{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}
So here is the formula I would want to see:
If({=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}="01/01/2020","No Start Date",{=MIN(IF('Perform Billing Audit Report'!$B$2:$B$1500=Details!$D7,'Perform Billing Audit Report'!$E$2:$E$1500))}
Hope someone can help me!