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

Outcomes