[AccessD] OT - Excel - IIF in cell

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




More information about the AccessD mailing list