Link to home
Create AccountLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

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:","")
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Use the below one...

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

Saurabh...
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
Avatar of pdvsa

ASKER

Nice!  I have to put on my glasses.  Tough to see all of those parenth and commas.  

thank you