Formula Help Please!
I have a numeric formula field. Within the formula, I'm using 2 fields, a numeric field & a checkbox field. The numeric field (crew fee) should be displayed, but if you check the (pre-fee collected) checkbox, it should add a "PAID" to the right of the (crew fee). So the results of the formula should display either...
$200 or $200 PAID (for example)
Here's the formula I started, I know it's all over the place, I just cannot figure it out....
[crew fee] & If([PRE-FEE COLLECTED]=true, [crew fee]&" "<font color=red><b>PAID"</font>"", [crew fee])
Thank you so much if you understand what I'm saying and can help!!!
------------------------------
Michael Brumfield
------------------------------
$200 or $200 PAID (for example)
Here's the formula I started, I know it's all over the place, I just cannot figure it out....
[crew fee] & If([PRE-FEE COLLECTED]=true, [crew fee]&" "<font color=red><b>PAID"</font>"", [crew fee])
Thank you so much if you understand what I'm saying and can help!!!
------------------------------
Michael Brumfield
------------------------------
