Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Chart that has 4 columns with an expression wich gives the result 'X' or ''(space).
A fourth column has to be marked with an 'X' depending on if some of the four previous
columns has an 'X' or not.
I have tried this expression with rreference to columns name.
=if(([OmsG]='X','X','') or ([ROD]='X','X','') or ([roc]='X','X','') or ([POR]='X','X',''))
If I only use the first if it works but not when I add or
kindly
Håkan
try this Expression (if any of the four columns contain X, Show X, otherwise space
=if(([OmsG]='X' or [ROD]='X' or [roc]='X' or [POR]='X'),'X','')
try this Expression (if any of the four columns contain X, Show X, otherwise space
=if(([OmsG]='X' or [ROD]='X' or [roc]='X' or [POR]='X'),'X','')