add IF formula to calculated field for a pivot table

Hi,

I am adding several calculated fields to pivot table in Excel 2013 with no problem and result is calculated correctly.

Now I need to add IF Function to the last column in the pivot table and insert IF Function into it.

I've already added a calculated field titled Sum of Balance and it is the result of Credit - Debit.

The field I want to add suppose to be titled Status and the IF Function has 3 results:-

If value of the Sum of Balance Column = 0, then Status calculated field should equal to BALANCED

If value of the Sum of Balance Column > 0, then Status calculated field should equal to Credited

If value of the Sum of Balance Column = 0, then Status calculated field should equal to Debited

https://www.dropbox.com/s/tnschp4f8or8c8q/Balance_Debit_Credit.xlsx?dl=0

Thanks

June 30th, 2015 8:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics