Forum Discussion
AND IF in conditional column
Hi, I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns. What I'm looking for is something like this: If [COUNT...
What was the response to this.
I have similar situation for a custom column, i need to have values
if col1=a1 and col2 =a2 then '50'
else col1=b1 and col2=b2 then 100
and so on for 20 values
how to resolve this
Please see content from @gilbertiq, that would suit your needs