1. Select a cell in the Pivot Table report.
2. Press Alt+jt+j+f or you select option than Formulas and then Calculated Field.
3. In the Insert Calculated Field dialog box, type the formula name in the Name box.
4. In the Fields list box, select the first field name to insert and click Insert Field. The field name is copied into the Formula box.
5. Type / (in this example), repeat step 4 to insert the second field into the formula, and then click OK.
6. To format the new field, select a cell in the field and click the Field Settings icon on the Pivot Table toolbar.
see this......
Learn Office Excel
The knowledge of Microsoft Excel in your hand.
Thursday, August 4, 2011
Sunday, July 17, 2011
Use Excel Countif function
Use Excel Countif function when you want to see the count of a specific criteria
appear in a selected range.
For Example :
1.How many times does the name "jack"appear in a list of worker names?
2.How many prices higher than 1000 are there in a given price list?
see this video for reference
appear in a selected range.
For Example :
1.How many times does the name "jack"appear in a list of worker names?
2.How many prices higher than 1000 are there in a given price list?
see this video for reference
Saturday, July 16, 2011
Using multiple criteria with the “OR” functions
Hi friends this Post is Actually Posted by Mr. Amit Kumar. Specially thanks to him. Mr Amit is our new contributor and he is very happy to share his knowledge with us
The function “OR” is used in a same manner like "AND" function, but its meaning is slightly different.
Instead of checking if all its parts is met (as is the case of the “AND” function), it checks if at least one of the criteria inside it is met. If it is, then the whole “OR” is considered met.
Hence, in the following formula:
=IF(OR(C1>80,D1>80,E1>80) , “Good student” , “Average Student” )
Below here is a Demo Video of OR function with IF.
The function “OR” is used in a same manner like "AND" function, but its meaning is slightly different.
Instead of checking if all its parts is met (as is the case of the “AND” function), it checks if at least one of the criteria inside it is met. If it is, then the whole “OR” is considered met.
Hence, in the following formula:
=IF(OR(C1>80,D1>80,E1>80) , “Good student” , “Average Student” )
Below here is a Demo Video of OR function with IF.
You all can get more information about if statement from the bellow links.
Labels:
If Or function,
learn excel
Subscribe to:
Posts (Atom)