If and Case

From DataSelf Knowledge Base
Jump to navigation Jump to search

IF & CASE Statements in the Formula Wizard

Adding Making calculations after an If or Case Statement

You need to add both numeric fields first. Then select (highlight) the first numeric field, and click on the operator (+, -, X, /). The operator will then insert itself after the selected field.

You can put If statements inside a Case statement, but not a Case inside an If.