excelhelp Archives - Excel-Help

Mar312023 by excelhelp13No Comments

Find Percentage Per Product

In Excel, you can find the percentage of the total amount received from an order by using the following formula:= (Total amount received / Total amount of the order) * 100% Assuming that the total amount received is in cell C4 and the total amount of the order is in cell C11, you can enter the formula in cell D4 as mentioned in the example below. Please follow the steps given below and in the image: EXAMPLE 1 : Select a blank cell where you want to display the result. Right Click and Go to Format Cells and select Percentage Now The Cell will display the result in percentage after formula is applied. FORMULA as per this example : =$C4/$C$11 Dollar sign in the formula is to fixed the cell ranges. Once the formula is applied to the cell please hover to the bo...

Mar302023 by excelhelp13No Comments

Count Cells Excluding Specific Text

FORMULAS, Text

To count the number of cells excluding or omitting a Specific Text in a specified list or range of cell in Excel, you can use the excel COUNTIF function. Please follow the steps given below and in the image: Select a blank cell where you want to display the result or follow the image. Follow the formula and steps as per the example shown in the image below, Note : Make sure to change the range as per your data. EXCLUDE VALUE IS : Laptop FORMULA : =COUNTIF(A4:A8,"<>Laptop") In this example the range is (A4:A8). But you should change the range according to your data list / cell range. That's It :)

Mar292023 by excelhelp13No Comments

Count Cells That Start or End With Specific Text

FORMULAS, Text

To count the number of cells that Start or End With Specific Text in a specified list or range of cell in Excel, you can use the excel COUNTIF function. Please follow the steps given below and in the image: Select a blank cell where you want to display the result or follow the image. As per the example shown in the image, if you want to count the number of Cells that Start or End With Specific Text in the range A4:A8, you would use the formula as per this example. Note : Make sure to change the range as per your list. START WITH LT* Type the formula "=COUNTIF(A4:A8,E4) into the cell were you want to have the result. ENDS WITH *S Type the formula "=COUNTIF(A4:A8,E8) into the cell were you want to have the result. In this example the range is (A4:A8). But you shou...

Mar292023 by excelhelp13No Comments

Count Cells That Contains Text

FORMULAS, Text

To count the number of cells that contain text between specified list or range of cell in Excel, you can use the excel COUNTIF function. Please follow the steps given below and in the image: Select a blank cell where you want to display the result or follow the image. As per the example shown in the image, if you want to count the number of Cells that contain text in the range B4:B8, you would use the formula as per this example. Note : Make sure to change the range as per your list. Type the formula "=COUNTIF(A4:A8,"*") into the cell were you want to have the result. In this example the range is (A4:A8). But you should change the range according to your list / cell range. NOTE : This will also count the blank cells too as a text so you must check and remove the...

Mar42023 by excelhelp13No Comments

Number Formats In Excel

Home Menu, Menu Bar

Definition:- The Number Format Is A Special Code To Control How Values Are Displayed In Excel. Number Formats Change The Way Numeric Values Are Displayed. But They Do Not Change Actual Values. General - General Option Is The Default Option Applied By Excel For Any Value Number Or Text Format 1. Number:- Number Option Is Used For General Display Of Numbers. The Decimal Number Decimal Can Be Specified. if Want To Display Negative Numbers In Different Formats. 2. Currency:- The Currency Option Can Be Used To Specify Any International Currency Symbol With Numbers. And Also To Specify The Decimal Number. 3. Accounting:- Accounting Option Similar To Currency Option. The Accounting Option Can Set The Currency Symbols And Decimals Together. 4. Date:- With ...

Mar42023 by excelhelp13No Comments

CEILING Function in Excel.

Menu Bar, View

The CEILING Function Rounds a Number Up to its Nearest Multiple of Significance. CEILING Function helps to round up the numbers as per the requirement. Syntax: =CEILING(Number,Significance) Arguments: Number: The value that you want to Round Up. Significance: The Multiple that you want to Round Up. See the Examples in blow Image.

Mar42023 by excelhelp13No Comments

Translate Text into a different Language in excel

Menu Bar, Review, tips & Tricks

Excel Translate is a function that converts text in one language to another language. Mostly English language is used to present the data. However, you can change the default English language content to your own language. Steps- Select cell and Go to Review Tab Click on Translate 3. On the right-hand side, you will see the dialog box. 4. In the Search for, You will see the text of the selected cell. Or type the word you want to convert. 5. Select From - To language in the dialog box. 6. Click on Start Searching button. 7. It will translate the in Hindi as it is the selected translate language for this example..You can choose your language as per requirement. 8. If you click on Insert, it will insert the converted text to the acti...

Mar32023 by excelhelp13No Comments

Create Dynamic Dropdown list with Indirect formula

Data, tips & Tricks

A Dynamic dropdown list or dependent dropdown list is very useful while working in Excel. Which makes our work easier and time get saved. Here we have an example of how to create a dynamic dropdown list or dependent dropdown. Example- We have names of some states and their cities. While working in Excel, you should create a dropdown list so that you do not have to type the name of the state or it's city repeatedly. If we select the state name in dropdown the list of cities of that state will appear automatically. We have the following data. In which dropdown list is to be created in column F3 to G6. Steps- To create a dropdown list of state names Select F3 to F6 In the Data tab, Click on Data Validation. In the dialog box that opens, select “L...

Jun122022 by excelhelp13No Comments

How to Change Gridline Color in Excel

tips & Tricks

Gridlines are displayed in a workbook with a default gray color that is applied automatically. If you want to change the Gridlines color, follow the steps given below: Click on File tab >> Options >> Advanced >> Grid Color.Select the color you want to use and click ok. To see the changes go back to the worksheet.

Jun122022 by excelhelp13No Comments

Align text in center without cell merge

tips & Tricks

Merge and center command is often used to bring headings to the center. But doing so sometimes causes problems in the use of certain features, formulas, functions of Excel. We have the solution. Headings can be brought to the center without the use of merge and center command. Follow the Steps below. STEPS : 1 Select cell range. 2 Right click on selected range 3 Click on format cell... 4. In the format cell dialogue box, click on alignment tab 5. Open horizontal selection drop-down 6. Select center across selection. 7. Click ok 8. See the result in below image.