var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculated Control using If
I would like to write a formula such as: If [cost] is less than or equal to $1000, $10 for the fee, otherwise use the formula =(([Cost]-1000)/1000)*2+10
The formula shown works, but I cannot figure out how to write it as part of a conditional expression. As you have probably guessed, the field in the table is named "Cost".
What happens with the formula is that the result is sometimes less than $10, but the minimum has to be $10.
IIf(Cost < 1000, 10, (([Cost]-1000)/1000)*2+10)
That worked for me. Thanks a lot.