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.
Hello markmark3,
welcome to the forum. Is it possible that the text field has trailing or leading spaces?
Test your data and maybe change your formula to something like
=if(TRIM(ColumnA)*1=5000,true,false)
or
=if(value(ColumnA)=5000,true,false)
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks