Add a Credit to Script

[Bob]

=IIf([tbOverDueAmount]>1,"Overdue Amount:",Null)
How Can I add this to the Script <-1"Credit"

Thanks in advance.........Bob Vance

 

[Wayne-I-M]

Hi Bob

You can used a Nested IIF (but the second option is better - and makes more
sense). Use the help (F1) to learn more about Nested IIF's - you can have (I
think) up to seven in a formula.


=IIf([tbOverDueAmount]>1,"Overdue
Amount:",IIF[tbOverDueAmount]<-1,"Credit",Null))

Or

=IIf([tbOverDueAmount]>0,"Overdue Amount:","Credit")

Hope this helps