Jim Lawrence
accessd at shaw.ca
Wed Apr 25 15:26:21 CDT 2007
...Because it is not needed. Why the iif command was created when the functionality could have been extended to the already existing if statement has always been beyond me. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, April 25, 2007 7:52 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] OT - Excel - IIF in cell As always, immediately after I pressed Send I discovered the answer. =if((E3="x"),0,C3) Now why doesn't IIF work? John W. Colby Colby Consulting www.ColbyConsulting.com -----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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com