Dec 20, 2011
is it possible to have different formulas for different rows in the same column? for instance, I have 4 groups of rows and in a given column, I want a different formula for each row group. if yes, how do I do that?
Jun 23, 2011
No, you cannot have different formulas. But you can use the same formula that evaluates differently depending on group. Use If() or Match() functions to build conditional formulas,
If(:group=="A", :X+1, :group=="B", :X+2, :group=="C", :X+3, :group=="D", :X+4, 99999)