2 Data Validations in a Cell

[Dave Peterson]

As a general rule, there's nothing wrong with typing 0 into a cell. But if the
person who designed the workbook that you're using expects you to type your name
into that cell, then typing 0 into that cell would be wrong.

Does that help??

 

[d1g_666]

yes thanks mate,
because am doin' my ECDL exam and this question is one which i find it
hard to answer!
MAYBE BECAUSE AM NOT A VERY GOOD USER FOR THE SPREADSHEETS PROGRAMME!!
so thank you v. much you gave an idea that its not that big deal to
add the zero value if it blank.
because i thought it could damage the calculations.

ISSAM,

 

[Dave Peterson]

Ooooh....

I didn't say it wouldn't damage calculations. It could.

If you have a formula that adds things up:

=a1+a2+a3+a4+a5
or
=sum(a1:a5

Then you won't notice a difference.

But if you have a formula that averages the values in A1:A5
=average(a1:a5)
then the result could change.

Or even a simple function that counts the quantity of cells with numbers in
them:
=count(a1:a5)

Putting a 0 in that cell could change the results of the formula.

I'm not sure what an EDCL exam is, but if they have an option for "maybe", then
that's the one I'd choose!

 

[Max]

Dave, there's one secret you/others like you haven't really revealed ..
Going by the breathtaking rate that posts (new/follow-ups) are tackled here
and in the other excel newsgroups by you/others like you, how on earth do
you guys manage to track follow-up responses/feedback to your responses,
especially follow-up responses which might occur a mite later (.. could be
days ?? later, bearing in mind the exponential cumulative# that you/others
like you would have responded since). Just wondering at the wonder of it
all .. <g>

 

[Anne Troy]

Hi, Max. I wondered this for a long time, too. Then I found some article on
posting in the newsgroups and how I could create a rule so that messages
from me appear in red, and how to show the next unread message. When you
start visiting every day, it's much easier with these couple extra settings.
I think this was the article I read:
http://www.microsoft.com/Windows/IE/community/columns/newsgroups101.mspx
************
Anne Troy
www.OfficeArticles.com

 

[Dave Peterson]

I use an older version of netscape and all the responses to each new post are
grouped together. If I responded to a post, I can see any response to my
response--it's just indented under mine. So I read it and see if I need to post
another message.

For me, I don't do anything special--I just scan down the messages looking for
new posts.

 

[Max]

Thanks, Anne ! Think I'm also following the "red" lines in OE, albeit it
does get a little daunting over time, as the number of reds under monitoring
increases <g>. I do hop over now and then to: http://www.excelforum.com
for a quick check on any follow-ups posted to my responses (find it easier
to do so there, with a simple keyword search and the search facility's Sort
results by "Last Posting Date" in descending order).

 

[Max]

Thanks, Dave !