Excel -Testing Formulas and Lookups

These posts are beginning to look like diaries, well maybe it's a good thing.

Some formulas that helped me in handling data or messy data in organized ways in Excel.

Still using the same retail data file as last post.

For classification based on criterias into new categories, I'll be using IF or IFS:

For returning a part of a text string, I'll be using LEFT or RIGHT depending on which side I want to start searching from:

To combine a few columns and add some additional strings in between, I'll be using CONCATENATE:

Highlighted parts are the relevant columns involved.

If I wanted my values to show less decimals by rounding up or down, I would use ROUND:

Next update, adding in a few more Excel formulas together with various lookup functions.