Forum Discussion

Copper Contributor

Jan 13, 2023

Return non related value based on one, two or three cells

Cells A2:C2: are populated with text. How can I return a value to D2, that is determined by different combinations of A2:C2? Based only on whether or not A2:C2 values contain text or are empty. D2 wo...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jan 13, 2023

GaryW880

As variant

=SWITCH(SUM(ISTEXT(A2:C2)*{1,10,20}), 31, "x", 21, "y", 20, "z", "not defined")