Hi,

Thanks for your response. In the context of general excel functions and
calculations you are correct but I'm trying to generate a calculated field in
a pivot table. I can not make a reference to a specific cell.

I hope someone else can help me out there.

Thanks

"wjohnson" wrote:


Here is what I set-up and seems to work.

A B C
Name1 2 Ignore
Name2 3 1.5
Name3 3 Ignore

=IF(A2="Name2",B2/2,"Ignore")

try making a reference to the cell.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2300135