Add a Credit to Script

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

Thanks in advance.........Bob Vance
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12571-add-a-credit-to-script.html



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12571
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12571

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

Hope this helps

--
Wayne
Manchester, England.



"Bob" wrote:

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