How to multiply 4 columns together in a 40x7 table

Hi,

How do I multiply 4 columns of a table together and then output the answer in another column inside the same table. Additionally how do I repeat this for all 40 lines of the table?

[KSSV]

Read about table to array using array2table. And convert them to table using table2array.

Also you can access any column of table using T.(1), T.(2) etc,.

[Alex Jones]

I cant use tis function because 2 of my variables are types double and cell

[Walter Roberson]

rowfun() ?

[Alex Jones]

I have worked out a way to do this but I am now getting: Operator '.*' is not supported for operands of type 'cell'.

How do I fix this as I am multiplying within a table?

[Ameer Hamza]

Alex, as you mentioned, the variables are of type cell and double. At best, we can make a guess, but the suggested solution that will probably not work. It will be better if you can attach a sample table, similar to the original table you have. It will make it much easier to suggest a solution quickly.

Answer 1

[BALAJI KARTHEEK]

Hope this will help u out.....

in variable a u keep ur input matrix and in while size(a,2)<7: instead of 7 u keep ur no of required columns in ur case it is 41, if u have any furher doubts u can feel to contact me

clc
clear all
format long
a= [1 2 
    1 2
    1 2];
while size(a,2)<7
    for i=1:size(a,1)
        b(i)=1;
        for j=1:size(a,2)
            b(i)=b(i)*a(i,j);
        end
    end
    a(:,size(a,2)+1)=b;
end
display(a)