Hi guys,

I want to ask this.

In Excel =if() function, I can have if certain condition is true then I get a value from a certain cell, otherwise I get another value from another cell.

How about I have 6 different input cells, and 6 different conditions, feed in to one cell. Like if the condition is 1 then I feed target cell with value from cell 1. And if the condition is 2 then I feed the only target cell with value from cell 2.

The cell can handle multiple different conditions?

Thanks.