IF Formula Syntax
An IF statement is the most commonly used expression that Microvellum uses when creating formulas. The IF statement is also one of the easiest expressions to understand. The IF statement simply looks to a condition that you specify. If your condition is true the expression will return the TRUE value, and if the condition is false the expression will return the FALSE value.
The syntax for an IF formula is:
=IF(Variable=Value,TRUE,FALSE)
Formulas can evaluate to different combinations of values, but there are different requirements for each value. For instance, if we wanted to have an IF statement evaluate to a string, or word, then you would need to include that word in parentheses. If that string is a defined name, then you do not need to include it in parentheses because it needs to evaluate that defined name.
Example: =IF(Variable=1,Variable,"Variable")
So, if Variable does equal 1 then the value of Variable, which is 1, (the true answer) will be returned. Otherwise if Variable does not equal 1 then the text between the quotes (the false answer) will be returned as a name (exact text between quotes, including any spaces or characters) not a value.
Additional References: