Hi,

I'm looking for a simple formula, where if there are text / numbers in 3 different columns, then return specific text

For instance: if A1, B1 and C1 contains text/numbers, then in D1 if should return Multiple Category

Similarly if only A1 contains text/number, then in D1 if should return Single Category

If it is more than 1, then return Multiple else Single. And if no text in A1 to C1, return blank