ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Formula (https://www.excelbanter.com/excel-discussion-misc-queries/218019-pivot-table-formula.html)

PFLY

Pivot Table Formula
 
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.

Pecoflyer[_90_]

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


PFLY

Pivot Table Formula
 
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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com