Insert an 'OR' operator into an StrCnd

Tue, 30 Apr 2013 08:38:23 GMT

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

Re: Insert an 'OR' operator into an StrCnd

sushil353 — Tue, 30 Apr 2013 08:49:02 GMT

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