Subscribe Bookmark RSS Feed

formulas in columns

tonyuow

Community Trekker

Joined:

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?

thanks

1 REPLY
ms

Super User

Joined:

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,

Example:

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