-
Solved: Array Formula Question
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules