IIF Syntax Problem

Novice1

Registered User.
Local time
Today, 08:54
Joined
Mar 9, 2004
Messages
385
I cannot figure out what is wrong with this syntax. Any help would be appreciated.

=IIF(IsNull[RSN_Increase]), “$ __________”, ("Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")
 
I cannot figure out what is wrong with this syntax. Any help would be appreciated.

=IIF(IsNull([RSN_Increase])), “$ __________”, ("Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")

Unless there is a typing error, I think you might be missing a pair of parentheses (see above). Let us know if that makes any difference.

-- Rookie
 
I'm still getting an error - Wrong number of arguments
 
Try

=IIF(IsNull([RSN_Increase]), “$ __________”, "Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")
 

Users who are viewing this thread

Back
Top Bottom