Your example above will work fine, as long as you're careful to put all the closing parentheses at the end.
If (TC=395 .And. R="", amount,if(TC=362 .And. R="",-1*amount, if(TC=395 .And. R="R", etc etc /b[/quote]
Something's not quite right.
See if [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=4;t=000066#000000"]this[/url] helps at all
I keep getting operand count error message. What does that mean? /b[/quote]
[size="1"][ May 19, 2006, 01:27 PM: Message edited by: Todd Niemi ][/size]