| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Using "IF" function in calculated fields
Hi
I tried using an "IF" function in a calculated field of a pivot table, to return different text values based one of the summarised base fields in the pivot table. Am getting "#VALUE!" in the cells of the calculated field column. How do we use "IF" functions in a calculated filed? Thanks Pawan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
| Pivot Tables - how do I add in calculated fields? | Excel Worksheet Functions | |||
| Help Please! - Creating Function Calculated Fields within Pivot Tables | Excel Worksheet Functions | |||
| How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions | |||
| Pivot Tables, calculated fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
