Hi,
I came across a condition written like below in a Multi-Row formula tool where two IIF statements joined using an asterisk(*). Could someone explain the use of writing such statement?
IIF([value1]>0,1,Null())*IIF(id_person] == [Row-1:id_person],something, something)
Thanks.
Solved! Go to Solution.
The statement:
IIF([value1]>0,1,Null())*IIF([id_person] == [Row-1:id_person],somethingA, somethingB)
is just equivalent to:
IIF([value1] > 0, IIF([id_person] == [Row-1:id_person],somethingA, somethingB), Null())
The only difference is in the second case the inner IIF is only evaluated if first is true.
... or ...
IF [Value1] <= 0 THEN Null()
ELSEIF [id_person] = [Row-1:id_person] THEN SomethingA ELSE SomethingB ENDIF
Guys, I have a data set and i want to count the number of columns where i have info ( text and date ). I have X columns, but i want to look only at the last 24 of them. Something like CountA ( AA1:BA1). I couldnt find a simple formula.
thanks
I also need to know how to count text or date fields; where I'd use COUNTA in Excel.