Great recommendation, Paul! Thanks for the fast reply.
The IF works! it populates the before and after text, including the Cash_Credit value. However, having one small issue now. When the source value contains no data (null; empty cells in Excel) the Comparison Operator <> doesn't identify this, but still populates the before and after text.
i.e. You were selected to receive a cash credit of which will be mailed to the address we have on file.
Also, here are a few things that I've tried, but didnt work:
>= 1
!= 0
Any additional help will be greatly appreciated.
|