AnsweredAssumed Answered

Multiple IF Statements

Question asked by don_ramage on Aug 14, 2018
Latest reply on Aug 14, 2018 by beverly

I want to create a filed giving the statuses of balances in another field. My if statement givers me only 2 options?


If ( current_month_bal < 0  ; "Overspent" ; "Zero or in Surplus" )


But I would like 3 options:

1. Overspent

2. In Surplus

3. Zero Balance


Any suggestions would be most welcome.  FM Pro 16