| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If statements in Pivot Table Calculated Fields
Hi,
Is it possible to use an "if" statement in a calculated field if that "if" statement is referring to a result in another field? Formula= if(field1="happy", 0, if( field1="sad",1,if(field1="neutral",2,"field1 was not completed"))) Thanks, Carmen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| pivot table question, sum fields? | Excel Worksheet Functions | |||
| Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions | |||
Threaded Mode
