Forum Discussion
Divide a quantity as whole number among multiple cells
Hello, Any suggestion for an excel formula to derive A2, B2, C2, D2 values. Eg: Category X A B C D P1 4 1 1 1 1 P2 3 0 1 1 1 P3 2 0 1 1 0 Y 1 3 3 2 ...
Why P2 and P3 the value for column A is "Zero". Is there any constraint?
I guess you need to provide more details so we can try to help you.
I understood that what you want is fill the adjacent columns of X values so the sum of the values of these colums (A to D) will represent the X value. But I could not understand the logic behind P2 and P3 because for instance P3 could be A=1;B=0;C=1;D=0 or A=1;B=0;C=0;D=1 resulting in 2 anyway.
I guess you need to provide more details so we can try to help you.
I understood that what you want is fill the adjacent columns of X values so the sum of the values of these colums (A to D) will represent the X value. But I could not understand the logic behind P2 and P3 because for instance P3 could be A=1;B=0;C=1;D=0 or A=1;B=0;C=0;D=1 resulting in 2 anyway.
Hi, the p3 and p2 values are zero because the values need to to sum up to the y columns aswell. So essentially i want the formula to consider the values of x rows and y columns and fill it to 1 if the two constraint is not met and even if one of the constraints fail i woul like it ro return 0
