Make Words Plural Excel Formula
where wordtable is the named range F5:G11. If the number in column B is greater than 1, the result is a “pluralized” noun. If the number is one, the result is the original (singular) word. Ingredients In the example shown, the formula uses these ingredients: IF function – to check the number of items VLOOKUP function – to lookup irregular plural forms IFNA function – to take action when there is no irregular form Concatenation – to glue text together...