If statement with non-numeric data in a pivot table

[misterfluff]

Im trying to do a pivot table in which one column is a calculated field based on non-numeric data (eg the if statement is
If('Question'="why",'Answer',0), where 'Question' and 'answer' are fields), but i just get 0 for everything.

If I change the logical test to a numerical one it works, but then if its a numerical test and the false value is non numeric (say, IF('Number'=5,'Prime',"Gosh") then whenever it is false it just says #VALUE instead of Gosh. yet with the same test, if i swap "Gosh" for a numeric field it works.

What is going on? How do i solve this?

 

[misterfluff]

hey, can anyone help with this?

 

[markmzz]

You will generally get much more help (and faster) in this forum if you can post your small samples of the sheet (what you have and what you expect to achieve) directly in the forum.

Use the link below for helper.

http://www.mrexcel.com/forum/showpost.php?p=2545970&postcount=2

Markmzz