In this example Column A gives us a written number One, Two or Three. Column B gives a descriptor and Column C gives us an animal. If the answer results in Three Fat Cat, I would like to know if it’s possible to create an if statement that would recognize the result of
=CONCAT(INDEX(A1:A3, RANDBETWEEN(1,3))," “,INDEX(B1:B3, RANDBETWEEN(1,3)),” ",INDEX(C1:C3, RANDBETWEEN(1,3)))
So that if Two or Three were written, it would then Concatenate an additional “s” to make the outcome more accurate, but to the specificity that I would add the “s” to cat and rhino, but not to moose.