Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
710
Conditions in formula
posted

Hello,

 

I have a Calcmanager in a grid and it works fine for simple formula.

But now I want to include a formula like: If(([ColumnA] = 'valA' & [ColumnB] = 'ValB'),'A',B')

but it looks like only the second condition ([ColumnB] = 'ValB') is taken into account. How can I combine conditions in a IF statement in a formula? I have tried several things without success.

 

Also, what is the equivalent of 'OR' in such formulas? I would like to have a formula like 

 If(([ColumnA] = 'valA' OR [ColumnA] = 'ValB'),'A',B')