Using VBA Excel to create a gramatically correct list

Question

I need to find a way to write a list using ',' and 'and' in the correct manner based on a varying number of items in a list

Answer 1

The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the OR function.

Comma style format is also referred to as thousands separator.

This format will be very helpful when you are working on a large table of financial sales data (Quarterly or half or Annual sales data), Comma style format is applied here, and numbers appear better. It is used to define the behavior of digits in relation to the thousands or lacks or millions or billions of digits. Comma Style format offers a good alternative to the Currency format. Comma style format inserts commas in larger numbers to separate thousands, hundred thousand, millions, billions, and so on.

Comma style is a type of number format where it adds commas to large numbers, adds two decimal places (i.e. 1000 becomes 1,000.00), displays negative values in closed parentheses & represents zeros with a dash (–).

The shortcut key for comma style is ALT + HK.