Use of rowfun and varfun

I have a table that looks like this

A B C Var1 Var2 Var3

--- --- ----------- ---- ---- ---

1000 10 'Index' 1 2 3

3000 20 'Index' 2 3 4

5000 30 'NotIndex' 3 4 5

5000 40 'Index' 4 5 6

I want to manipulate Var1, Var2...…based on the the values in A, B and C…I have an exteranl function that does the manipulation needed.

If I use rowfun I can only manipulate one VaR at a time. If I use varfun then I cant figure out how to pass A, B and C

[madhan ravi]

Expected result?

[Niraj Shah]

When C = 'Index', then A*B*Var1, A*B*Var2 etc...

else A+B+Var1, A+B+Var2...

so result should be

Var1 Var2

------- -----

10000

120000

5333

[madhan ravi]

Do you see why you didn’t receive a proper answer? More illustrations needed, it’s not clear atleast for me.

Answer 1

[Abhivandan Pandey]

Hi Niraj,

You can get multiple output using rowfun as well.

Please refer to the following link:https://www.mathworks.com/help/matlab/ref/rowfun.html#bty705b-4

As shown in this link you need a function that returns 3 outputs (Var1,Var2,Var3 in your case).