- How to Count Numbers in Excel
- How to Count Cells Containing Anything in Excel
- How to Join Cells in Excel
- How to calculate running total in Excel
- How to Add Numbers in Excel
- How to Subtract Numbers in Excel
- How to Divide Numbers in Excel
- How to Multiply Numbers in Excel
- How to Calculate Percentage in Excel
- How to Hide Rows in Excel
- How to Insert Comments In Excel
- How to Edit Comment In Excel
- How to Delete Comments In Excel
- How to Draw Borders In Excel
- How to Add Numbers in Excel with 5 Variations
- How to Wrap Text in excel
- How to Merge Cells in Excel
- How to use Transpose Formula In Excel
- How to Highlight Cell in Excel with Conditional Fo
- How to use Conditional Formatting In Excel
- How to Make Column Chart In Excel
- How to Calculate LCM In Excel
- How To Use Number Formatting In Excel
- How To Use IF Formula In Excel
- How To Use CountBlank Formula in Excel
- How to Use Date Formula Excel
- How To Use Paste Special in Excel
- How To Use Hours, Minutes, Seconds In Excel
- How To Sort Data In Excel
- How To Use Date Formula In Excel
- How To Use Month Formula In Excel
- How To Use Dictionary in Excel
- How To Use Hyperlink in Excel
- How To Do Translation in Excel
- How To Covert Number to Currency format with Dolla
- How To Use Full Screen View Mode In Excel
- 7 Ways to Use Vlookup in Excel
- How to Insert Checkbox in Excel
- 7 Ways to Use Vlookup in Excel
- Excel Shortcuts
- Learn Excel Online
- Use Checkbox in Excel to Make Checklist in Excel
- Use Formula in Pivot Table in Excel
- How to Use Formula in Pivot Table
- Find Duplicate Value in Excel
- Use Vlookup with If Formula in Excel
- How To Make List in Excel
- How to make Sparkline Charts in Excel
- How to make Comparative MIS Report in Excel
- 4 Types of Progress Chart in Excel
- How to Make Progress Chart in Excel
- How to make Sales Dashboard in Excel
- How To Use Text to Column in Excel
- How to do Data Entry Work in Excel
- How to Make Payment Due Report in Excel
- How to Make Quotation in Excel
- How to Make Price List in Excel
- Find Duplicate Remove Duplicate Value in Excel
- How To Do Data Entry Work in Excel
- Use Countif Function in Excel
- Vlookup with If Formula in Excel
- How To Make List in Excel
- How to calculate Rank in Excel
- Convert Row to Column in Excel
- 10 Ways to Use Paste Special in Excel
- How to Use Averageifs Formula in Excel
- How to Use Filter In Excel
- Create Invoice in Excel
- Compare 2 Lists in Excel
- How to Sort Data in Excel
- 12 Number Formatting Options in Excel
- Text Formatting with Wrap Text and Merge Cells in
- 5 Ways To Use Averageif Formula in Excel
- 3 Ways to Use Hlookup in Excel
- Vlookup for Beginners in Excel
- 8 Ways to Use Countif Formula in Excel
- Nested IF Formula In Excel
- Show Formulas in Dropdown List in Excel
- How to Use Macro in Excel
- Sales Report Software in Excel
- If Formula in Excel
- 4 Advanced Pivot Table Options in Excel
- How To Stop Duplicate Values Entry in Excel
- Make Pivot Table From Multiple Excel Sheets
- How To Remove duplicate in Excel
- Change Number to Text in Excel
- Hlookup in Excel
- MIS Report in Excel
- How To Calculate Percentage in Excel
- Vlookup Duplicate Repeated Values in excel
- Vlookup From Multiple Tables in Excel
- How to Change Cell Color Based on Value of Another
- Vlookup with IF Formula in Excel
- Make Dashboard In Excel
- Use If Formula in Pivot Table
- Use Formula in Pivot Table in Excel
- Index and Match in Excel
- Countblank Formula in Excel
- How to Use Scenario Manager in Excel
- Horizontal Sort in Excel
- Pivot Table in Excel
- 5 Advance Excel Formula
- Make dependent Drop Down List in Excel
- Copy Files Names From Folder Automatically
- Compare 2 Lists in Excel with Vlookup
- Add in Excel
- Average in Excel
- Make Salary Sheet in Excel
- 5 Excel Shortcuts
- How To Use Double Vlookup in Excel
- 7 Ways To Use Vlookup in excel
- How to Delete All Blank Cells and Rows in Excel
- 5 Excel Formula Most Used in Office
- Double Vlookup in Excel
- Make Timeline Chart in Excel
- Use Spin Button in Excel

- How to Count Numbers in Excel
- How to Count Cells Containing Anything in Excel
- How to Join Cells in Excel
- How to calculate running total in Excel
- How to Add Numbers in Excel
- How to Subtract Numbers in Excel
- How to Divide Numbers in Excel
- How to Multiply Numbers in Excel
- How to Calculate Percentage in Excel
- How to Hide Rows in Excel
- How to Insert Comments In Excel
- How to Edit Comment In Excel
- How to Delete Comments In Excel
- How to Draw Borders In Excel
- How to Add Numbers in Excel with 5 Variations
- How to Wrap Text in excel
- How to Merge Cells in Excel
- How to use Transpose Formula In Excel
- How to Highlight Cell in Excel with Conditional Fo
- How to use Conditional Formatting In Excel
- How to Make Column Chart In Excel
- How to Calculate LCM In Excel
- How To Use Number Formatting In Excel
- How To Use IF Formula In Excel
- How To Use CountBlank Formula in Excel
- How to Use Date Formula Excel
- How To Use Paste Special in Excel
- How To Use Hours, Minutes, Seconds In Excel
- How To Sort Data In Excel
- How To Use Date Formula In Excel
- How To Use Month Formula In Excel
- How To Use Dictionary in Excel
- How To Use Hyperlink in Excel
- How To Do Translation in Excel
- How To Covert Number to Currency format with Dolla
- How To Use Full Screen View Mode In Excel
- 7 Ways to Use Vlookup in Excel
- How to Insert Checkbox in Excel
- 7 Ways to Use Vlookup in Excel
- Excel Shortcuts
- Learn Excel Online
- Use Checkbox in Excel to Make Checklist in Excel
- Use Formula in Pivot Table in Excel
- How to Use Formula in Pivot Table
- Find Duplicate Value in Excel
- Use Vlookup with If Formula in Excel
- How To Make List in Excel
- How to make Sparkline Charts in Excel
- How to make Comparative MIS Report in Excel
- 4 Types of Progress Chart in Excel
- How to Make Progress Chart in Excel
- How to make Sales Dashboard in Excel
- How To Use Text to Column in Excel
- How to do Data Entry Work in Excel
- How to Make Payment Due Report in Excel
- How to Make Quotation in Excel
- How to Make Price List in Excel
- Find Duplicate Remove Duplicate Value in Excel
- How To Do Data Entry Work in Excel
- Use Countif Function in Excel
- Vlookup with If Formula in Excel
- How To Make List in Excel
- How to calculate Rank in Excel
- Convert Row to Column in Excel
- 10 Ways to Use Paste Special in Excel
- How to Use Averageifs Formula in Excel
- How to Use Filter In Excel
- Create Invoice in Excel
- Compare 2 Lists in Excel
- How to Sort Data in Excel
- 12 Number Formatting Options in Excel
- Text Formatting with Wrap Text and Merge Cells in
- 5 Ways To Use Averageif Formula in Excel
- 3 Ways to Use Hlookup in Excel
- Vlookup for Beginners in Excel
- 8 Ways to Use Countif Formula in Excel
- Nested IF Formula In Excel
- Show Formulas in Dropdown List in Excel
- How to Use Macro in Excel
- Sales Report Software in Excel
- If Formula in Excel
- 4 Advanced Pivot Table Options in Excel
- How To Stop Duplicate Values Entry in Excel
- Make Pivot Table From Multiple Excel Sheets
- How To Remove duplicate in Excel
- Change Number to Text in Excel
- Hlookup in Excel
- MIS Report in Excel
- How To Calculate Percentage in Excel
- Vlookup Duplicate Repeated Values in excel
- Vlookup From Multiple Tables in Excel
- How to Change Cell Color Based on Value of Another
- Vlookup with IF Formula in Excel
- Make Dashboard In Excel
- Use If Formula in Pivot Table
- Use Formula in Pivot Table in Excel
- Index and Match in Excel
- Countblank Formula in Excel
- How to Use Scenario Manager in Excel
- Horizontal Sort in Excel
- Pivot Table in Excel
- 5 Advance Excel Formula
- Make dependent Drop Down List in Excel
- Copy Files Names From Folder Automatically
- Compare 2 Lists in Excel with Vlookup
- Add in Excel
- Average in Excel
- Make Salary Sheet in Excel
- 5 Excel Shortcuts
- How To Use Double Vlookup in Excel
- 7 Ways To Use Vlookup in excel
- How to Delete All Blank Cells and Rows in Excel
- 5 Excel Formula Most Used in Office
- Double Vlookup in Excel
- Make Timeline Chart in Excel
- Use Spin Button in Excel

**Scenario** If you spend an average of $25 on food each week, and you want to cut your weekly food expenditures by 25%, how much can you spend? Or, if you want to increase your weekly food allowance of $25 by 25%, what is your new weekly allowance?

If B2 is the amount that you spend on food, and C2 is the percentage you want to decrease that amount by, you can enter **=B2*(1-C2)** in D2 to find the result:

In this formula, **1** is used to represent 100%. Similarly, if you wanted to increase the amount by a certain percentage, you would enter **=B2*(1+C2)** in D2:

**Scenario** If you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.

If B2 is the price and C2 is the sales tax, you can type the formula **=B2*C2** in D2, as shown here:

This formula multiplies 800 by 0.089 (the underlying percentage in decimal form) to find the sales tax to pay.

**Scenario** For example, if a student scored 42 points correctly out of 50 on a test, what is the percentage of correct answers?

In this scenario, if the number in B2 is points answered correctly and the number in C2 is the total points possible, you can type the formula **=B2/C2** in D2 to find the grade.

This formula divides 42 by 50 to find the percentage of correct answers. (In the example shown here, the grade is formatted as a percentage without any decimal places showing.)

**Scenario** For example, the sale price of a shirt is $15, which is 25% off the original price. What is the original price? In this example, you want to find 75% of which number equals 15.

If B2 is the sale price, and C2 is 0.75, which is 100% minus the 25% discount (in decimal form), you can enter the formula **=B2/C2** in D2 to find the original price:

This formula divides the sale price by the percentage paid to find the original price.

**Scenario** For example, the earnings for your department are $2,342 in November and $2,500 in December. What is the percentage change in earnings between these two months? To do this task, use the subtraction (-) and division (/) operators in a single formula.

If B2 represents November earnings, and C2 represents December earnings, you can use the formula =(C2-B2)/ (B2) in D2 to find the difference:

This formula divides the difference between the second and first numbers by the value of the first number to obtain the percentage change. (In the example shown here, the difference is formatted as a percentage with two decimal places.)