Prev: Freeze the side column/top row & scroll others
Next: Why i can not protect sheet
From: Simon on 21 Mar 2010 20:07
Hi,

I'm using excel 2007, I have a pivot table and I'm trying to create a
calculated item, the formula for the Calculated item is:
IF(MID('Project Title',7,1)="S", .20, .10)
The Project Title field contains text and if the 7th character of the
project title field is "S" I want the calculated item to return .20 otherwise
..10, but for some reason it is always returning .10.

Am I doing something wrong here?

Thanks.
Simon
 | 
Pages: 1
Prev: Freeze the side column/top row & scroll others
Next: Why i can not protect sheet