[mso] Re: fORMULAS IN eXCEL 2007
- From: Thomas Hutchins <hutch99999@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 30 Apr 2009 07:27:43 -0700 (PDT)
I prefer to check the length of the cell's contents:
=IF(LEN(A1)=0,value,A2)
This is slightly faster (see the section on VBA optimization in the Access
Cookbook from O'Reilly Press for an explanation & execution time comparison).
Or, Excel has an ISBLANK function you could use:
=IF(ISBLANK(A1),value,A2)
For a single formula, they are all pretty much equivalent.
Hope this helps,
Hutch
--- On Thu, 4/30/09, Jim Hi
ckey <jim@xxxxxxxxxxx> wrote:
From: Jim Hickey <jim@xxxxxxxxxxx>
Subject: [mso] Re: fORMULAS IN eXCEL 2007
To: mso@xxxxxxxxxxxxx
Date: Thursday, April 30, 2009, 8:47 AM
Richard,
I use the following =if(a1<>"",value,a2)
HTH
Jim
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Richard Howard
Sent: Thursday, April 30, 2009 8:41 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] fORMULAS IN eXCEL 2007
Hi
I would like to write an IF formula in excel. I know how to do IF
statements, however I need to write one that refers to a null value - an
empty cell. How is this written into a IF statement? The formula needs to
say IF cell A1 is null, return value refer otherwise return what is written
in cell A2
Hope that makes sense & I look forward to hearing from you
Thanks
Richard
[cid:image001.jpg@01C9C9A1.9E5AACB0]
[cid:image002.gif@01C9C9A1.9E5AACB0]
Richard Howard
European Marketing Manager
rhoward@xxxxxxxxxxxxxxxxxx<mailto:njones@xxxxxxxxxxxxxxxxxx>
Tel: (+44) 0161 333 2485 Mob: 07812 057290
Web: www.rentsmartworld.com<http://www.rentsmartworld.com/>
7th Floor Oakland House, Talbot Road, Manchester, M16 0PQ
This correspondence is for the use of the named person only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately notify the sender and delete it
from your system. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient. Any opinions expressed
in this message are those of the individual sender, except where the sender
expressly, and with authority, states them to be the opinions of RentSmart
Ltd
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
Rentsmart LTD, registered no. 3689086 England & Wales, 7th Floor, Oakland
House, Talbot Road, Old Trafford, Manchester, M16 0PQ
______________________________________________________________________
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister
group. This group will not allow for posting of emails, but will allow you
to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.12.4/2081 - Release Date: 04/29/09
18:03:00
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister
group. This group will not allow for posting of emails, but will allow you to
join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
