Variables and different calculations to be made

Discussion created by mz5005 on Nov 9, 2016
Latest reply on Nov 10, 2016 by mz5005

I have 2 variables A and B. based on the values of these two,different calculations have to be made.

of course if A and B have many possible values i will define a table.

but in a case when there are only 2x2 or 2x3 possibilitie, that seems clumsy to me. so do many if/else's.

what i need is a DO CASE / CASE1 CASE2 kind of command.

how is that best done in fmp? can't see anything like it in the reference guide.

any input highly appreciated!