Nested If

Experts, I get the wrong number of arguments error in the below.  I dont know if I can do what I am trying to do.   Let me know if you see a comma misplaced or a parenth or if my logic is completely off on this one.  

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:","")
pdvsaProject financeAsked:
Who is Participating?
 
PatHartmanCommented:
You have an extra argument at the end.

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:"))

Or, you have the closing paren for the first IIf misplaced.

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:"),"")
0
 
Saurabh Singh TeotiaCommented:
Use the below one...

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:"),"")

Saurabh...
0
 
Rey Obrero (Capricorn1)Commented:
lets evaluate what you are trying to do

for the first IIF expression
=iif(Nz([PastDueYN],"")="", <WhatValue>
if the expression is True, what value do you want to show in the <whatValue> portion
0
 
pdvsaProject financeAuthor Commented:
Nice!  I have to put on my glasses.  Tough to see all of those parenth and commas.  

thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.