Change Label if Negative (1 Viewer)

[chuckster]

I have a field [field3] that subtracts [field1] from [field2]. Both of the other fields are calculated in themselves.

I want a label to change what it says depending on the value of [field3]. That is if [field3]<0 then label1 = "Customer Owes Us" if [field3] is >0 then label1 = "We owe Customer.

Thanks in Advance

 

[llkhoutx]

Try: iif (field3<0,"Description 1","escription 2")