June 10th, 2007, 10:16 AM
|
 |
National Security Advisor
|
|
Join Date: Oct 2001
Location: Toronto, Canada
Posts: 5,624
Thanks: 1
Thanked 14 Times in 12 Posts
|
|
Re: Need help with formula
Your parenthesis were not correct.
It should be like this:
iif([%Level%] > 3, ([%Level%] - 3) * 2, 0)
The general format for iif is:
iff(Condition, TRUE, FALSE)
|