JWColby
jwcolby at colbyconsulting.com
Wed Apr 25 09:45:41 CDT 2007
I need to do a simple iif in a cell: =iif((E3="x"),0,C3) IOW what I am trying to do is say if the cell E3 = "x" then the current cell = 0 else the current cell = the contents of cell C3 All I get is the infamous #Name? Is it possible to do this? Is there some other construct? John W. Colby Colby Consulting www.ColbyConsulting.com