Getting an garbage value - If condition is not meet.
Getting an garbage value in column E Row 48.
If the condition do not match in the given below formula then it should remain blank.
I am using this formula =IF(D12<>"",NETWORKDAYS(D12,C12,'US Holidays'!$B$3:$B$14)-1,NETWORKDAYS(B12,C12,'US Holidays'!$B$3:$B$14)-1)
For Row 48 formula is - =IF(D48<>"",NETWORKDAYS(D48,C48,'US Holidays'!$B$3:$B$14)-1,NETWORKDAYS(B48,C48,'US Holidays'!$B$3:$B$14)-1)
Attached Excel for reference.
You have no end date?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That's because the resolved date is blank for this row. You need to check if it is blank and return a value that means something to you.
Thanks for quick response.
Yes, I know the resolved date is blank, so if it is blank then it should not through garbage value instead it should be blank.
=IF(ResolvedDate is blank,"This is garbage",your formula)
No, your formula is testing for D being blank, not C - you would need to test for them bothOriginally Posted by Shahbazk
another way:
=IF(C2="","",NETWORKDAYS(IF(D2<>"",D2,B2),C2,'US Holidays'!$B$3:$B$14)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks