Eric Barro
ebarro at verizon.net
Wed Apr 25 10:01:26 CDT 2007
Because IIF is not a supported function in Excel. -----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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.463 / Virus Database: 269.6.0/775 - Release Date: 4/24/2007 5:43 PM