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

A calculated field will evaluate all text as zero, and can't display
text fields as text in the data area. So, all the calculations would
show zero.

Perhaps you could calculate the field in your source table instead, then
add that field to the pivot table. Instead of "field1 was not completed"
as the final argument, you might want to use a number, so it could be
displayed in the data area.

Carmen wrote:
> 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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html