[AccessD] OT - Excel - IIF in cell

I think in Excel it's just 'if' not 'iif' - just one i

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of JWColby
> Sent: Wednesday, April 25, 2007 10:46 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] OT - Excel - IIF in cell
> 
> 
> 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
>  
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>