ExcelBanter - Pivot Tables - Using "IF" function in calculated fields

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables - Using "IF" function in calculated fields (https://www.excelbanter.com/excel-discussion-misc-queries/183650-pivot-tables-using-if-function-calculated-fields.html)

pjalan

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

All times are GMT +1. The time now is 08:12 PM.