Prev: Excel 2003 giving annoying "Send/Don't Send" error when closing
Next: Excel 2007 will not convert to XPS or PDF
From: craig on 28 Jan 2010 23:08
Hi, my question is..I want to use an If formula based on the Grp colomn value
BU (see formula below), but it doesnt recognise the value as "BU", it just
returns the false value (value if false).

Pivot table rows are as follows
SO # Grp Cust Whse SO
311450 BQ BAKERS S 10-Nov-Tue
312385 0 MODERN S 12-Nov-Thu
312403 BU BUNNINGS S 12-Nov-Thu

I have inserted a calculated field with formula
=IF(Grp="BU",0,1)
The formula always returns 1
Thanks for your answer
 | 
Pages: 1
Prev: Excel 2003 giving annoying "Send/Don't Send" error when closing
Next: Excel 2007 will not convert to XPS or PDF