Number Formats

This Addin will help you to change the format of the selected range to number formats listed below by just one click.

No Decimal: Number with no decimal.
Million: Number format will change to million.
Billion: Number format will change to billion.

Click Here to Download Addin

To know how to add Addin Click Here.

How to Add an Addin

Below steps will help you add Excel Addin to an Excel. (I am using Excel 2010 screenshot may differ in other versions)

1. Copy the Addin.

2. Go to File and click on Options.

3, Now Click on Addin at the bottom click on Go

4. Click on Browse, a Folder will open. Paste the Addin in the folder and click on open.

5. Now Go to File-Option-Customize-Choose command from(Select Macros)- Customize the Ribbon( Select Main Tabs)  

6. In Customize the Ribbon go to home and select the last option. Now click on New Group and Name the group.

7. Now click on the group and select the Addin you want to add in Choose Command From section and click on add.

8. After the macro is added in the new group click ok. Now the Addin will be visible in Home Ribbons.

For any queries drop a comment.

Expand & Collapse Addin

Below is an Excel Addin that you can add to your excel.

To know how to add Addin Click Here.

This Addin will help you to Expand Or Collapse columns and rows grouped in all the sheets in an Excel Workbook/File.

Click Here to Download

If(And())

If with And helps to add multiple conditions where all condition are required to be meet/fulfilled.
In the below example if first cell name is yellow and the other is green then the formula with return value as true or false.

If(Or())

If with Or helps to add multiple conditions where one of the criteria is required to be meet/fulfilled.
In the below example if cell name is either yellow or green the formula with return value as true or in any other case false.