[mso] Re: Two questions about Excel
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 10 Dec 2002 15:38:42 -0500
In an IF statement, Excel sees blank cells as 0 (zero)...but it will NOT see
cells with a space in them as zero.
The formulas that are linked to another workbook won't update til you open
the workbook and say Yes to Update the Links.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Colli, Anthony G
Sent: Tuesday, December 10, 2002 1:42 PM
To: MSO FreeLists (E-mail)
Subject: [mso] Two questions about Excel
Folks-
I need to do some comparisons in Excel. Basically if this cell = this value
then I want this output. I need to write this in a function that can be used
in other spreadsheets. I have written the function and it works but here is
my question. How does Excel treat a blank or empty cell? is it's value '0'
or "" or null?
Also when I am working with this and I modify the function, is there a way
to recalculate the spreadsheet? After I change the function the values are
not updated.
-Anthony
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
