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