Community Trekker

Joined:

Dec 20, 2011

## formulas in columns

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?

thanks

Super User

Joined:

Jun 23, 2011

## formulas in columns

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,

Example:

If(:group=="A", :X+1, :group=="B", :X+2, :group=="C", :X+3, :group=="D", :X+4, 99999)