[AccessD] OT - Excel - IIF in cell

In Excel the function is simply IF
Also you don't need the parens around the logical test.

=If(E3="x",0,C3)

HTH

Jim 
jhewson at karta.com
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Wednesday, April 25, 2007 9: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