Insert an 'OR' operator into an StrCnd

[#1]

Hi,

I would need this StrCnd works not only when starting by '!JOURNAL=' but also when starting by other values.

ColXtr(1, RowCnd(CellValue, 1, StrCnd(start, '!JOURNAL=')), 10)

It should be something like this, but it is syntactically wrong:

ColXtr(1, RowCnd(CellValue, 1, StrCnd(start, OR( '!JOURNAL=',  '!STANDARD='  ,  '!REGULAR='   )), 10)

What sintaxis I need?

Thanks

[sushil353]

Hi Try this:

	RowCnd(CellValue, 1, StrCnd(start, '!JOURNAL=')),
	RowCnd(CellValue, 1, StrCnd(start, '!STANDARD='))

Note that there is comma after first row.

HTH

Sushil