Calculated Fields and Text

[Tarver]

In a pivot table, can I insert a calculated field to evaluate a text entry?

My calculated field is
=IF(DESCRIPTION="C",AMOUNT*10)

My result is always 0, regardless of whether or not the corresponding entry is a C or not.

If I reverse it and make my field look for inequality, I get this:
=IF(DESCRIPTION<>"C",AMOUNT*10)

This results in every single entry (even those that are C) being multiplied by 10.

What am I missing?

 

[Robby19]

Is "DESCRIPTION" and "AMOUNT" a named cell? If not, then your issue is that excel doesn't know where to look for these. For example;

Use

=IF(B2="C",C2*10,0)

If you have your table set up as

	A	B	C	D
1	Name	Description	Amount	Formula
2	A	C	10	100
3	B	A	10	0

<tbody>
</tbody>

 

[Tarver]

Thanks for your response.

No, "DESCRIPTION" and "AMOUNT" are not named ranges. They are the fields in the PivotTable that I'm working with. In the PivotTable Calculated Field options box, it's possible to refer to those fields in building a formula for the Pivot Table to evaluate.

The formula that evaluates the contents of "DESCRIPTION" as being NOT equal to an entry works, so I know the formula is at least being processed. However, there's a syntax issue or some other limitation that I'm not aware of which is keeping the formula from working properly when the formula asks to evaluate DESCRIPTION as being equal to any text string.