[AccessD] OT - Excel - IIF in cell

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
 



More information about the AccessD mailing list