Can I have a pivot table formula return text?

I want to do an if statement and return the text "Yes" and "No" as a result
of the pivot table formula.

PFLY;200485 Wrote:
Can I have a pivot table formula return text?

I want to do an if statement and return the text "Yes" and "No" as a
result
of the pivot table formula.

What do you mean by "Pivot table formula"?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55181

Fomula - calculated fields.

"Pecoflyer" wrote:


PFLY;200485 Wrote:
Can I have a pivot table formula return text?

I want to do an if statement and return the text "Yes" and "No" as a
result
of the pivot table formula.

What do you mean by "Pivot table formula"?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55181