How to combine 3 IF formulas with 3 different value_if_false results into 1 formula

New Contributor

I have a matrix, 15 rows (A), 10 columns (B,C,D..). In a result should get a table returning 6 different results.

Need ONLY 1 formula to fit each cell.

Managed to create 3, which now need to be combined - not succeeding on my own.




2 Replies
best response confirmed by Ppetu999 (New Contributor)


Hi, this should work like this:


or with ";":


Alternatively, a bit shorter you could do a combination with LOOKUP().


or with ";":

Please try if this fits.

Great, the 1st version with ";" works for me well! Thanks a lot!