Thread: Excel, fill cells based on the information from another

Hello If I understand correctly you only need to use the function = IF logical condition; share1; Action 2 When the condition is met but held Action1 Action2, as more conditions you have to add one if within if, to further control them all. More or less like this: = IF (condition1; SHARE1; if (condition2; Action 3: if (condicion3; Action4; action 5))) Another option is to do it on VisualBasic code in a macro, but if you just want it so simple with so and dragging a formula for all cells that interests you already have enough.

Thank you very much, they will be about 30 different conditions, I guess it will not be excessive, right, because I no Visual Basic, although I have seen some programming language (Fortran only really), I have even rusty, the conditions and actions do not necessarily have to be information of a cell, right? I mean if I can fill the value within the formula itself, but I suppose I can do with cells, in which case you should set the $ cells do this from the master it and have used it more times to prepend the row or column to block the movement of row or column.

Hello 30 nested conditions Or what is the same one condition, within another within another 30 times, if this is the case you can go crazy writing formula and probably will not allow you much length the excel. In this case it would be much better a simple macro code using the "select case" where each "case" that the cell would you do such a value could be modified.