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.  

pdvsaProject financeAsked:
Who is Participating?
You have an extra argument at the end.


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

Saurabh Singh TeotiaCommented:
Use the below one...


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
pdvsaProject financeAuthor Commented:
Nice!  I have to put on my glasses.  Tough to see all of those parenth and commas.  

thank you
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.