I am trying to use an IF formula in a calculated field in a pivot table. I am using an outside data source and the field I want to use as the criteria in the IF formula is in text format. i.e.:
=if(columnA=5000,true,false) the result of this is always false.
Even if I change the formula to read:
=if(columnA="5000",true,false) all results come back false.
Any ideas on how I can get this to work with the text formated field?
Thanks.
Bookmarks