[AccessD] OT - Excel - IIF in cell

JWColby jwcolby at colbyconsulting.com
Wed Apr 25 09:51:41 CDT 2007


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




More information about the AccessD mailing list